MS Access 2007 Query Sum fields

Posted on 2011-04-27
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
    LVL 77

    Accepted Solution

    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

    Ok thanks.  I think you are correct though.

    Author Comment

    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

    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

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now