title: Is it possible to generate random numbers in MS Access that do not change everytime a query is run?
body: <p>I am trying to pull a random set of 200 records from my Microsoft Access database.  I created a query and used the rnd() function in a new field to generate a random number for each record.  I then sorted the random number field and retrieved the top 200 articles.  My problem is that every time I run the query, I get different random numbers.  I know that in other programs, you can set a user-defined value for the seed, and this problem will be fixed, however I do not know how to set the seed value myself in MS Access.  Is this possible to do?</p>
  
  <p>Thank you for your help!</p>