Simple Report Totals

[G-Man]

I have a report based on a query of the Amount Paid by indivuals and the
dates of payment. For simplicity:

Name----Date of Payment - - - -Amount Paid

I run the report preview and get:

This Name - - - date - - - - $20.00
That Name - - - date - - - - -$30.00
etc . . . .

next, I want a field that simply totals all the Amount Paid fields.

If I create a text box in the footer, and, for it's control source I put =
SUM([Amount Paid]) But the report displays an error in this control when I
preview it.

I have not done much with calculated fields. But I look at an invoice in the
sample northwind database and it looks that easy. What am I missing???

 

[Al Campagna]

G-Man
Is AmountPaid a calculated (on the form) field? If so, you can't sum it directly.
I'll assume AmountPaid is calculated... and that, for example, it might be something
like...
= Price * Qty
In the query behind the report, create a calculated column like this...
AmountPaid : Price * Qty
Now, AmountPaid is a "bound" field. Place a text control onnthe report with a Control
Source of AmountPaid, and in any footer...
=Sum(AmountPaid)
will yield the total for that group.

If not, please provide more info on how your current AmountPaid is derived.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."