How do I run a ck register report, credits and debits?

H

Heather

I have a table with a register id, check number (which is 0 if it is a debit
and a check number if it is a credit), I have a register type field (c for
credit, d for debit) and an amount field. I would like to be able to run a
report where it shows the total of credits to debits. So possibly adding all
the c's and then adding all the d's and subtracting the two and displaying
the total?

I am not sure, and I am not sure how to write that. I think it goes in the
report footer in a text box from reading the help.

Any assistance would be terrific.

Thanks,
Heather
 
Top