I am trying to query a table with the fields - TRN, Date, Fastest_Time and Tournament_ID
What I wish to do is query the table and give an index number for each team (TRN) in order of the last time each competed (Date).
All the teams do not compete at all the tournaments.
The sort of info I need is thus
TRN / Tournament_ID / Fastest_Time / Date / Expr1
016 345 18.45 220701 1
015 344 17.25 120701 1
016 344 21.21 120701 2
011 343 22.22 010701 1
015 343 22.28 010701 2
016 343 23.10 010701 3
etc etc
The "Expr1" would be the indexing value.
In the past I have used DCount function in MS Access, but I have moved on to MySQL and UNIX which appears to be much faster.
Any help or ideas would be appreciated.
Nige.
What I wish to do is query the table and give an index number for each team (TRN) in order of the last time each competed (Date).
All the teams do not compete at all the tournaments.
The sort of info I need is thus
TRN / Tournament_ID / Fastest_Time / Date / Expr1
016 345 18.45 220701 1
015 344 17.25 120701 1
016 344 21.21 120701 2
011 343 22.22 010701 1
015 343 22.28 010701 2
016 343 23.10 010701 3
etc etc
The "Expr1" would be the indexing value.
In the past I have used DCount function in MS Access, but I have moved on to MySQL and UNIX which appears to be much faster.
Any help or ideas would be appreciated.
Nige.