Need to write a simple Sum Funtion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smilee8_28 - 17 Nov 2005 22:29 GMT

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?

Reply to this Message

OfficeDev18 - 17 Nov 2005 22:55 GMT

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.

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

Signature

Sam

Reply to this Message