How to prevent names from showing up more than once in multi-table query?(Screenshots

[FrankGrinds]

I need to generate a report which shows who the top salesmen are.



Shown below is a screenshot of the results of my query:


As you can see, most of the employees' names appear multiple times. I only want to see each employees name once and have each individuals' sales amount totaled.

Shown below is a screenshot of the query in design view:



And shown below is the screenshot for my "Sales" table.



Thanks in advance for any help.

- Frank

[June7]

Do an aggregate (Totals) query. Access Help has guidelines on building.

Or build a report using Grouping & Sorting with aggregate calcs in group footer. This will allow displaying detail records and summary results. Again, Access Help has guidelines.

[FrankGrinds]

Hello Super Moderator June7,

thank you for the timely response. I was able to get the result that I wanted, as you can see:



Now, just one more thing.

How can I limit the query so that it only shows the top 3 salesmen?

- Frank

[June7]

Use TOP. Open the query in design view. It is on property sheet.

[FrankGrinds]

This thread has been solved.