How to Create Report by Select Value

Moore71

DEVELOPER
Local time
Today, 08:40
Joined
Jul 14, 2012
Messages
158
Hi,
I have an issue with Access report.
I have a report that display total transactions. Now i want to insert Total fields like:
Total Cash Payments
Total Bank Transfer
Total Check Payment
Total Draft Payment
Total Balance
to display at the report footer. How do I go about this. What format do I use to filter and summarize each of these payment method at the report footer?

I will appreciate every response.
Moore 71
 
Assuming you have a field called [Cash Payments] in the underlying Table/Query of the report, you would put a field in the reporter footer with this control source:

=SUM([Cash Payments])

Also, if that is in fact your field name, you shouldn't use spaces in field names--it just makes coding and querying a little more difficult.
 
Thanks for the quick response.
But what I am really looking at is how to filter the various amount where the records are on Cash Payment, check deposit, Draft, Bank Transfer, since all payments are in the same column in multiple rows.
I want to sum all cash payments, all draft, all Bank Transfer and so forth.

Regards,
Moore
 
Along the lines of:

=Sum(IIf(FieldName = "CashPayment", AmountField, 0))

Or a subreport based on a totals query, which is probably what I'd do.
 

Users who are viewing this thread

Back
Top Bottom