How to Create Report by Select Value (1 Viewer)

M

Moore71

DEVELOPER

Local time

Today, 19:12

Joined

Jul 14, 2012

Messages

158

• Dec 11, 2015

• #1

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

 

P

plog

Banishment Pending

Local time

Today, 13:12

Joined

May 11, 2011

Messages

11,658

• Dec 11, 2015

• #2

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.

 

M

Moore71

DEVELOPER

Local time

Today, 19:12

Joined

Jul 14, 2012

Messages

158

• Dec 11, 2015

• #3

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

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 11:12

Joined

Aug 30, 2003

Messages

36,128

• Dec 11, 2015

• #4

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.