Sum and Group in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that has my agents names, codes, and sales submitted. I'm
trying to figure out how to write a query that will show each agent code and
the total ammount of sales submitted. I've tried using the total on and
group, but I just can't figure it out. If anyone can help me please do.
Thank you!
 
Hard to give more than generic advise without field and table names.

Start with only two fields in your totals query;
Field: AgentName
Total: Group By

Field: SalesAmount
Total: Sum

IF that works then try adding in other fields that you need ONE at a time. Run
the query, note the differences from the previous step. You should soon
discover how the totals query works.
 
Back
Top