Sum a column

[dickjo5]

I have a report that list individuals, amount paid, date paid, etc. I would like to sum the column amount paid.
In getting a Count, I created a text box in the footer section of the report and entered =Count(*). That works fine, but when I creat a text box and enter =sum(amount Paid), I get nothing.
As you can tell already by my question, I'm a newbie to Access and need all the help I can get. Thanks.

 

[Sohaila Taravati]

Put =sum(amount Paid) in the Report Footer

Sohaila

 

[dickjo5]

I tried creating a text box in the report footer and entering =sum(amount paid), but in the layout form the sum doesn't show up. I get the text =sum(amount paid). I'm going astray somewhere, but can't figure it out. Thanks for any help.

 

[David R]

Did you enclose your field name in brackets?

Access doesn't like field names with spaces (actually, it's more forgiving than most programs), but if you have one you can try Sum([Amount Paid])

David R

 

[dickjo5]

Thanks for all the help but, unfortunately, I don't have the solution yet. I even changed the field name to "AmountPaid" instead of "Amount Paid" but no joy.
Again, thanks for the help, but I think I'll let it rest for awhile.
Regards,
Dick J