need urgent help with report

hi

please email me if you can help.... ([email protected])


my "sql" TQUERY sorts out the correct records and sorts them by day-
mon-year and transaction type = C (credit) or D (debit)
and there can be a variable number of records found including zero.  

my QR report currently does some of what i want but i dont know how 
to modify it to do exactly what i want..

rebpageheader
rbdetail
rbpagefooter


Page Heading:  accounts for april 2002 

rbDETAILband
listings:  day    transaction   c or d   inv#   stock      amount
           04     badges          c        N      Y         5.00
           05     hire of hall    d        N      N       (25.00)

etc.etc.etc

Page footer:  Page: xxx                              total:(20.00)


amendment required is to put all credits on one page and debits 
second page... plus obviously have the end total refer to appropriate 
amounts BUT if going over to 2 pages, the total DOES not print until 
2nd page.

IDEALLY, i would like to complicate matters by having credit / debit 
side by side - but this is way out of my league!

anyone help !????????????????

andy.