Results 1 to 2 of 2
  1. #1
    cyro is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2012
    Posts
    1

    How to insert more sums into Access query?

    I have a multiple query with 7 columns. while using Totals, the totals wor at the bottom appears with drop-down menus including:
    - none
    - count
    However, I need the sums for each of the columns.
    Could anybody advise me?


    Thank you very much !!

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Create the query manually, using the Totals option. You can then specify totals for any of the columns you select.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. INSERT query: insert new data only
    By drh in forum Access
    Replies: 2
    Last Post: 04-04-2014, 05:31 PM
  2. Query that sums a field based on 2 tables
    By scratchmb in forum Queries
    Replies: 6
    Last Post: 03-18-2012, 08:31 PM
  3. query that sums the data for me
    By citygov in forum Queries
    Replies: 4
    Last Post: 08-18-2011, 03:25 PM
  4. Replies: 1
    Last Post: 07-10-2011, 11:20 PM
  5. Access insert into query...
    By xmetisx in forum Queries
    Replies: 2
    Last Post: 04-06-2010, 02:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums