Thanks CP, done it now.

I actually have a field called RaceID which is the concatenation of Date&Venue&RaceNo so made it a bit easier. Only problem is how long it takes - a couple of minutes to process 1 month.

I found some code here:
http://www.access-programmers.co.uk...ead.php?t=55156
which does it in a couple of seconds.


Cheers

Thanks for the link Chinbok - I'll investigate it later.

Speed is not an issue for me though as I won't be ranking by query (each time that is) just updating a make table for export.

A couple of considerations though....

How will you handle records that have a blank for data and records that have a 0, and tied records etc.

My ranking system is more complicated than a straight code.

I have to consider that two horses with $20,000 prizemoney are not necessarily the same, one may have 20 starts and one may have one start.

So API comes into play.

The same applies with two horses with $0 prizemoney.

It's never "plug and play" :(

Mate, that's a luxury, when I first started doing rankings in Excel 6 years ago, some "bright spark" told me to do a sumproduct and array calculation which took more than 8 hours for a few months data!!!

It only dawned on me later that a simple sort and rank formula would take less than a few minutes - and that was the copy and paste time ;)

:D