[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: See data
- Subject: Re: See data
- From: Fatima Bagaria <FatimaB@LIMON.CO.ZA>
- Date: Thu, 6 Apr 2000 18:14:45 +0200
Hi all
Please help!!
I'm new at this as the following will show:
This is a list of records I need to print, BUT I only need to print the
amount once the date changes.
ID Description Date
Amount
500 Annuity Fund
31/12/2000 800.00
500 Annuity Fund
31/12/2000 -95.26
500 Annuity Fund
31/12/2001 -1.200.200.50
group by clauses,
if $ID <> &ID
Let #ind = x
and on-break commands have proven useless.
It's obvious that a total needs to be calculated for records with the same
ID, Description and date.
BUT HOW???
All help in securing my job sincerely appreciated..