Hello, I've been trawling the web trying to find how to build the expression to rank how many machines an individual has sold by date and to assign points for the ranks - so he who sold the most 6points, 2nd 4 points, 3rd 3 points, 4th 2 points 5th 1 point.

This is how my query is set out

Sales are stored in the table [Weekly Machines Sales Data]
the people are Vendeurs

(oo this is giving me a headache!) - thanks so much for the help

I have uploaded a zip with the db file in it here http://cid-4490afdc094900ec.skydrive...DC094900EC!368



I'm aiming towards having a ranking with value assigned for most machines sold and largest margin for each seller and for each team(equipe) for any given date period