Query that displays fixed # of results randomly?

[Delta223]

Hi,

I have a simply query that returns data from a single table (& no calculations or anything complex) The table has only abut 15 entries and the query displays the same 15.



I would like the query to randomly select & display 5 of the entries. Is there any easy way to do this?

Thanks

[ajetrumpet]

see something like: http://www.databasedev.co.uk/random_query.html

I also write for that website. It's probably a good tutorial. Also, you're going to want to use 'SELECT TOP 5' in your statement, combined with the RND() function, as illustated in that article.