[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: See data



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..