Query columns/rows MS Access

Posted on 2012-08-22
Last Modified: 2012-08-22
The table below is a result of a parameter query that sums up all data (records) from the beginning up to AS of DATE parameter [01/01/2012] (Sum of Data 1), [02/01/2012] (Sum of Data 2), [03/01/2012] (03/01/2012).  The table below is what I get:

Month Name      Sum of Data 1      Sum of Data 2      Sum of Data 3
January            136      
February                                                        162
March                                                                                            158

Is there a way to put the result in 2 columns (Month Name, SUMS).

Month Name      SUMS
January                     136
February                    162
March                     158
Question by:emacyam
    LVL 65

    Accepted Solution

    <wild guess>

    SELECT [Month Name], Nz([Sum of Data 1],0) + Nz([Sum of Data 2],0) + Nz([Sum of Data 3],0) as sums
    FROM YourTable

    Author Closing Comment


    I guess its only complicated when I make it one :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    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 how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    737 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

    21 Experts available now in Live!

    Get 1:1 Help Now