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
=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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thanks,
Lucy
ASKER
matthewpatric, I did make sure the field names matched the query, and moved to the footer of the report, I'm getting a #ERROR.
ASKER
After I revised the column names I found a mistake, corrected it, as matthepatrick suggested and it worked perfect.
Thank you very much,
Lucy
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?
:)
Any particular reason, then, why I got none of the points?
:)
ASKER
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??
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??
=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.