Results 1 to 2 of 2
  1. #1
    dhogan444 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    12

    Query help with Sums

    I am looking for a little help with queries, I will write a simpified version of what I am trying to do.

    tblCustomers (Fields: ID, LastName, FirstName)
    tblHardware (Fields: ID, HWName, NetworkID, CustomerID, Quantity)
    tblNetworks (Fields: ID, Name)

    So basically a customer can assigned multiple hardware types for multiple networks.



    When I run the query I get a list of the users with the above fields (repeated multiple times for each hardware). Instead I'd like the query to list each customer once, and then have count/sum columns for each piece of hardware for each network?

    How tricky is this? I am trying to get the query perfect so I can easily export to excel for reporting purposes.

    Thanks guys,

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Take a look at Aggregate (Totals) Queries in Access's help files. This will allow you to SUM fields by specified grouping.

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

Similar Threads

  1. Query that sums data
    By accessnovice78 in forum Queries
    Replies: 3
    Last Post: 04-12-2012, 11:46 AM
  2. Replies: 1
    Last Post: 03-23-2012, 09:45 AM
  3. Query that sums a field based on 2 tables
    By scratchmb in forum Queries
    Replies: 6
    Last Post: 03-18-2012, 08:31 PM
  4. query that sums the data for me
    By citygov in forum Queries
    Replies: 4
    Last Post: 08-18-2011, 03:25 PM
  5. Replies: 1
    Last Post: 07-10-2011, 11:20 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