sum of column help

[patrichek]

Hi,
I'm new to access so please be kind.

I'm running a report based on a query and I need to add up the total of one column.
The report shows name, date, phone, seminar and number attending seminar. How do i get a total of number attending in the footer of my report?
I've tried a text box with control source =sum([NoAttending]) but it doesn't add up the column, I get an "error"

thanks in advance!

 

[patrichek]

ok, nevermind! I didn't have the text box in the report footer, it was in the page footer!! geesh!