Shared Tutorials


  Shared Tutorials New
  Website Development
  2D & 3D Graphics
  Audio & Video Editing
  Databases
  Desktop Programming
  Operating Systems
  Business Applications
  Miscellaneous
  Selected Reading

© 2011 TutorialsPoint.COM


  Top Tutorials     New Tutorials     Submit     Login     Register     Forums  

Shared Tutorials Directory

Tutorials Shared by the Community




  • 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.
    http://www.databasedev.co.uk/random_query.html

Tutorial Statistics

  • Total Hits: 1412

  • Average Rating : URL RatingURL RatingURL RatingURL RatingURL Rating

  • Total Votes: 0 votes

  • Category: MS Access/Query Languages

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

  • Submitted By: Shekhar

  • Set as Favorite

Tutorial Detail ( View Tutorial )

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.

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...




  

Advertisement

Online Image Processing

Indian Baby Names