MS Access 2007 Query Sum fields

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-06-27
With the new feature in MS Access 2007 query columns can be summed directly on the query.  Is there a way to bring these sums over to a report based on that same query?

Question by:LindaOKSTATE
  • 3
LVL 77

Accepted Solution

peter57r earned 200 total points
ID: 35477001
Don't think so.

As far as I know, they only exist in the query display.

Wait for a while for other replies though.

Author Comment

ID: 35477007
Ok thanks.  I think you are correct though.

Author Comment

ID: 35478296
Is there a way to get a distinct count without adding a subreport?  I have a column that has 26 records, but only four of them are distinct.  is there some way to put syntax in a text box to get a count of the distinct items?  something like =count(distinct[value])?  I know this doesn't work but is there some other way?  I hate to make a new query and subreport for just one number.

Author Comment

ID: 35478646
I added a group header using the column i wanted to count, added a text box with a control source =1, did a running sum overall, made it invisible and then added a text box in the report footer using the text box from the group header as the control source.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question