Max totals

[Dave]

Hi

I have report that shows my 5 salesmans weekly total number of sales. That
is each week I enter the number of sales made by each salesman into a table.
I have a query where I enter the dates for the period I am looking at and it
shows each weekly total for each salesman. I want to have another report
that will show the highest number of sales for a week per a salesman. I'm
stuck! I realise that i need to do something with Max but how do i get it
to show me each salesman along with the max number of sales during the time
period?

Any ideas?

Thanks

 

[Dave]

No problem sorted it! Queries on queries!