Totalling on a report

[kbrooks]

Is there a way to have the total for a field on a report, without it being in the query? Maybe I'm going about this backward...

I have a database that tracks data for our financial assistance program (fap), and they have asked for a report that shows the total fap payments for the last 12 months for a certain individual.

I set up a query that prompts them to enter the SS# of the individual, and also to enter a starting date. My report is pulling from that query. It displays all the various fap payments this individual has had over the year, but I'd like a total amount at the bottom. I played with the Sum function in the query but was unable to get it to work how I wanted it to. (I clicked the Totals button, and then under the fap_payment and adjustment_payment fields, changed the GroupBy to Sum)

I'm not sure if I should concentrate on making it total in the query, or if it's just as easy to get a total on the report.

Thanks in advance!

 

[Rich]

=Sum([fap_Payments]) in the control source of a textbox in the report footer

 

[kbrooks]

You know, that's what I thought would work also. But I was getting #Error when I ran the report, so I assumed I was wrong. The fap_payment field is a calculated field all ready, does that make a difference?