#### Space Cowboy

##### Member

- Local time
- Today, 05:15

- Joined
- May 19, 2024

- Messages
- 245

I found this forum through research on working with dates where I found information on "MAX". It didn't quite meet my requirements so I thought to myself why not join the group and try to contribute in some small way.

I have a huge database with some 50 tables and it goes back 10 years. Every time I have used help to calculate bonuses etc. it always gets out, and spoils everything, so I am leaning "the way" myself.

I have figured out how to link tables in query and have tried to simplify the huge amount of data down to "one day" in an attempt to keep the data set manageable while I try to learn what is going on, eventually I will run it on the whole data set.

Here is my problem, that I hope may be solvable using the procedures in queries. I have had to change names etc due to data protection necessities and hope that my breakdown of the problem makes sense and is understandable.

On any day I may have upto 10 sales people working, (not always the same people)

each person can sell upto 10 items of varying value.

(Of course I don not want these numbers to be limiting factors)

Problem one,

**I want to aggregate together each persons sales into a total and rank the totals one to 10, highest total sales to lowest.**

Problem two,

**I need to identify the sales from each person, on that day, and rank them in order one to 10. Highest value to lowest.**

I would like to think that its easy to solve, if only I had the right terms to ask the question, but I have come to dead end.

The ultimate conclusion is that I want to generate a report that selects the five most recent dates that each person worked, some may only work once or twice a month, and look at their performance on the days that they worked.

The report, I hope, will ultimately help me to identify the top performers and reward them as such with bonuses and gifts etc.