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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering a report based upon a subtotal 2
Total in a Report 21
summing a text box 1
How do I query a calculated control? 1
Year to Date 5
Matching Debits and Credits in same column 4
Match Debits and credits? 3
Simple Question on Addition 3

Top