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