Totals in reports

T

Tony Williams

I thought this was easy! I have a report with a control called NbrAdults. I
have created a calculated control in the page footer called adults whose
record source is =Sum([NbrAdults]) as I want to count how many adults are
coming to an event so I thought it was just a simple Sum function. The
control NbrAdults holds values of 1,2,3 etc. However on my report I get
#Error. What am I doing wrong, I'm sure I've done this many times before.
Thanks
Tony
 
T

Tony Williams

Sorry found the problem I'd put the totals in the page footer rather than
the report footer
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Subreport totals in a main report Group footer 3
Total or pre calculated column 5
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
A03 - count in report footer gives me #Error? 0
Total not correct in Footer 2
Sum function in report not working properly 5
Can't see calculated control 2
Report Calculation 2

Top