Simple Form Totals

[Guest]

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

 

[Guest]

Please check that the textbox that shows the amount does not have the same
name as the field that holds the amount. Once you change the text box name,
use that in your sum and see if that works.

Please let me know if this works and if I can provide more assistance.