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

Report Calculation 2
Calculate Subreport totals in a main report Group footer 3
Counting and totaling from a subreport 6
Total or pre calculated column 5
Reports, Sub-reports running sum and no data 2
Total not correct in Footer 1
Totals not working 3
Counting records in group not working - Access 2007/WinXP 4

Top