I have a table displaying sales people, their clients(each person could have
any number of clients), and the amount $$ each client bought from the sales
person. I am trying to design a query to display the top 3 or 5 clients
according to $$ for each sales person.

Any Thoughts?

-Rob

In the query try something like

SELECT [M1].[sales person], [M1].[ClientName]
FROM [Sales Table] AS M1
WHERE M1.[ClientName] In (SELECT Top 5 M2.[ClientName]
FROM [Sales Table] as M2
WHERE M2.[sales person] =M1.[sales person]
ORDER BY M2.[Amount] Desc)


--
\\// Live Long and Prosper \\//
BS"D


"Rob Rhatigan" wrote:

> I have a table displaying sales people, their clients(each person could have
> any number of clients), and the amount $$ each client bought from the sales
> person. I am trying to design a query to display the top 3 or 5 clients
> according to $$ for each sales person.
>
> Any Thoughts?
>
> -Rob

Rob Rhatigan wrote:
>I have a table displaying sales people, their clients(each person
> could have any number of clients), and the amount $$ each client
> bought from the sales person. I am trying to design a query to
> display the top 3 or 5 clients according to $$ for each sales person.
>
> Any Thoughts?

Maybe normalize the table structure? Normally if you have sales people
with clients (more than one) you would split that up into two tables one for
sales people and one for clients linked to the sales people. I might add
that you may well want to have a third table for sales. Is it possible that
one client may have sales from more than one sales person? What happens if
a sales person leaves?

>
> -Rob

--
Joseph Meehan

Dia duit