Hello again,

How could I insert the ID column without it affecting the sort?

Thanks,

Bigtimeconfused

Hi

I got around the problem by adding another time column to the table and used Min(Time) again and bingo it worked! Thanks!

SELECT Sex, Distance, MIN( [Time]) AS [Time], MIN('TIME2') AS...

oh wow it is so close now please help i beg!! haha

Its the last word on the first line Time it doesnt like:

SELECT Sex, Distance, MIN(Time) AS Time

With:

SELECT Sex, Distance,...

The first line creates a problem:

"The select statement includes a reserved word or an argument that is misspelled or missing, or the punctuation is incorrect"

I am not sure whats wrong...??