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.live.com/redir.aspx?resid=4490AFDC094900EC!368"][/URL]
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
Thank you
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.live.com/redir.aspx?resid=4490AFDC094900EC!368"][/URL]
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
Thank you