How to display total by category at the end of the report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Friends,
I am preparing database of the money collected from clients. The money can
be in cash or by cheque. In the monthly report, I want to display the total
amount collected in cash and by cheque. I tried to place it in the report
footer, but it showed error. How can display the cash total and cheque total
at the end of the report?
If anyone requires, I can send the database; which is in Access 2003 version.
Hope I will achieve what I want,
Maulik Bhatt
 
Maulik Bhatt said:
I am preparing database of the money collected from clients. The money can
be in cash or by cheque. In the monthly report, I want to display the total
amount collected in cash and by cheque. I tried to place it in the report
footer, but it showed error. How can display the cash total and cheque total
at the end of the report?
If anyone requires, I can send the database; which is in Access 2003 version.
Click to expand...


You didn't say how you distinguish one kind of payment from
another or how the amount is stored so I'll just guess that
there is an Amount field in the report's record source
table/query (*not* a control on the report) and that there
is a Cash field that is True for cash and False for checks.

Based on the above assumptions, use text boxes in the report
footer with expressions like:
=Sum(IIf(Cash, Amount, 0))
and
=Sum(IIf(Not Cash, Amount, 0))
 
Thanks Marsh

Actually, I have placed a field named "PaymentMethod", the value of which
may be either cash or cheque. But I will change the design of the database
accordingly.

I am a novice in the field of database. I know there is a function in
Microsoft Excel, named sumif. But I didn't know how to proceed in Access in
such situation. Thanks again. Will write you again if I will require
 
Back
Top