Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Sum multiple values in an Access 2010 Report

Posted on 2012-04-12
Medium Priority
979 Views
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
Question by:lucyLuna
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 4
• 2

LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 37841053
=Sum([w]) + Sum([x]) + Sum([y]) + Sum([z])
0

LVL 61

Expert Comment

ID: 37841065
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

Author Comment

ID: 37841066
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

Author Comment

ID: 37841083
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

Author Comment

ID: 37841107
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

LVL 93

Expert Comment

ID: 37841160
>>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

Author Comment

ID: 37841287
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
###### Suggested Courses
Course of the Month5 days, 12 hours left to enroll