Using a Query to display Random Records

Tutorials Shared by the Internet Community

Advertisements


Using a Query to display Random Records

This article details how we can display random records from a Microsoft Access table using the Rnd function in our query.

Statistics

  • Total Hits - 36049

  • Total Votes - 111 votes

  • Vote Up - 48 votes

  • Vote Down - 63 votes

  • Domain - www.databasedev.co.uk

  • Category - MS Access/Query Languages

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:39:38

Description

This article details how we can display random records from a Microsoft Access table using the Rnd function in our query. There may be times where we need to see a sampling of records from the table and we might want to return 20 records at random.<br /><br />If we just apply the Rnd() function in the query, the function is only evaluated a single time, therefore the function will return the same value for each record in the query.    More detail...


Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements