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