Select one Record at random from a Select Query 1

[XP2000]

I'm struggling to pull one record at random when using a select query with a WHERE clause.

Table = TblPlayers has 2 relevant fields: NAME & SEASON.
I need to select just one RANDOM record WHERE the season="2004-05".

I'm sure this is an elementary question, but I just can't figure it out.

 

[PHV]

Has TblPlayers an unique numeric field ?
If yes, say myID, you may try something like this:
SELECT TOP 1 Rnd(myID), ...
FROM TblPlayers
WHERE season='2004-05'
ORDER BY 1;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244