Sum multiple values in an Access 2010 Report

Access 2010 Report is pulling data from a query, all info is correct and fields are summed up as required, except for a grand total, I have tried;

=Sum[Column A]+[Column B]+[Column C] but nothing happens, I have recreated jist of the report in an Excel Attachment.

***Keep in mind my report is in Access 2010...NOT In Excel!!!

Your help is very much appreciated,

Lucy
Excel-Example-of-Access-Report.xls
lucyLunaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
=Sum([w]) + Sum([x]) + Sum([y]) + Sum([z])
0
 
mbizupCommented:
This needs to be in the footer of your report.

=sum([column a]) + sum([column b]) + sum([column c])

Also make sure that these are the names of fields in your query, not the names of textboxes on your report.


—----
Completely missed the above comment.  Sorry about that.
0
 
lucyLunaAuthor Commented:
Hi matthewpatrick, this goes in the Control Source field right? I tried it and it's not adding up...any ideas as to why?

Thanks,

Lucy
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
lucyLunaAuthor Commented:
matthewpatric, I did make sure the field names matched the query, and moved to the footer of the report, I'm getting a #ERROR.
0
 
lucyLunaAuthor Commented:
After I revised the column names I found a mistake, corrected it, as matthepatrick suggested and it worked perfect.

Thank you very much,

Lucy
0
 
Patrick MatthewsCommented:
>>After I revised the column names I found a mistake, corrected it, as matthepatrick suggested and it worked perfect.

Any particular reason, then, why I got none of the points?

:)
0
 
lucyLunaAuthor Commented:
I accepted your solution and awarded all points to you...I must have done something wrong...I'll check...sorry, this is crazy, I can't seem to get a handle on this grading and acceptance system.


I just realized wha happened,  I thought you were the only one responding to the question...so someone else jumped in, and I did not ralize it was not you...how can I fix this??
0
All Courses

From novice to tech pro — start learning today.