Sum and Group in Query

[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!

 

[John Spencer (MVP)]

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.