Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 983
  • Last Modified:

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
0
lucyLuna
Asked:
lucyLuna
  • 4
  • 2
1 Solution
 
Patrick MatthewsCommented:
=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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now