Need to write a simple Sum Funtion

S

smilee8_28

I have a query which pulls out payments made depending on a date parameter
given. Then I have a report based on the query which sorts the payments by
where the payment was received. I need a total of payments received for given
date for each location. Where do I put the Sum Function and what should it
look like?
 
O

OfficeDev18 via AccessMonster.com

Your query has to be sorted by location, but contain the amounts as well. You
don't want a Totals query, because you want to report on all the detail
payments.

In your report, put the detailed payments in the Detail Section, and make two
footer sections, one for location (the upper one) and one for payment amount
(the lower one). In the location footer, put text boxes for both location and
sum of amount. In the payment footer, put a single text box for summing the
amount.

Alternatively, you can have just the location footer and put the total
payment amount in the report footer.
 
Top