Month: November 2011
-
How to write a ranking query in MS Access
One of my little jobs here at work is to produce a report for two year groups of students that ranks their results on three different subjects that they take. The easy way to do this with MS Excel is to use the RANK function operating on a whole set of results and it works…