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

[Maulik Bhatt]

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

 

[Marshall Barton]

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.

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

 

[Maulik Bhatt]

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