Combine Duplicates in Query

May 5, 2016
Reaction score
I am trying to build a query that totals an agent's productivity for a specific period of time. I do not know how to have the query combine the duplicate entries for each agent, though. I have it to where it is pulling the data I want for the start - end date and showing the table info I'm looking for, just not combining it into one line per agent with the sums. Instead each agent is listed 5 or 6 times with a record for each day of productivity. I might add that it is impractical to run a query for each agent. Is there a simple solution that I'm just not aware of? No experience in macros or SQL.
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question