Link to home
Start Free TrialLog in
Avatar of lucyLuna
lucyLuna

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of lucyLuna
lucyLuna

ASKER

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
matthewpatric, I did make sure the field names matched the query, and moved to the footer of the report, I'm getting a #ERROR.
After I revised the column names I found a mistake, corrected it, as matthepatrick suggested and it worked perfect.

Thank you very much,

Lucy
>>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?

:)
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??