Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Help me please w/ combining like customers

    Need help combining the sales and income for like customers by division and salesperson: Example below of all fields:

    Division Salesperson CustCode CustName YTDSales YTDIncom
    16 JSmith 1ABCEF ABCDEF 123.00 12.00


    16 HHill 2HUYT HUYTG 345.00 54.00
    16 HHill 2HUYT HUYTG 234.99 56.00
    16 HHill 2HUYT HUYTG 222.00 45.00
    15 TJones 1RUBB RUBBY 456.00 29.00
    15 TJones 1RUBB RUBBY 345.00 78.00
    15 TJones 1RUBB RUBBY 222.00 34.00

    If someone could please help me figure out how to make the like customers add together - I can get the rest. I can do it in a report - just not sure where to do this part - if it should be in a query or the report. Thanks so much for anyones help in advance! any help would be greatly appreciated! Laurie

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    One thing you could try is to run a 'Totals' query and select 'Group By' for customers and 'Sum' for your sales and income.

  3. #3
    Join Date
    Jun 2008
    Posts
    2
    Thank you! I have made some progress and wanted to thank you for your help!

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

Similar Threads

  1. Combining Two Queries
    By csolomon in forum Queries
    Replies: 1
    Last Post: 09-03-2009, 01:33 PM
  2. Replies: 1
    Last Post: 06-03-2006, 05:02 PM
  3. Combining Databases
    By RHall in forum Access
    Replies: 2
    Last Post: 04-13-2006, 07:36 AM
  4. Delete query, deleting customers froma table.
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-14-2006, 11:33 AM
  5. Help combining 3 tables
    By luscioussarita in forum Queries
    Replies: 1
    Last Post: 12-14-2005, 03:22 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