How to get random record from MS Access database

by

To get different random record you can use, which would require a ID field in your table

SELECT TOP 1 questionID FROM questions ORDER BY Rnd(-(100000*questionID)*Time())

A negative value passed as parameter to the Rnd-function will deliver the first random value from the generator using this parameter as start value. (A kind of defined randomize).
Special thanks to @kobik ‘s hint from the comments.

More Related Contents:

  1. How do i add percentage an Access query?
  2. How does one decompile and recompile a database application?
  3. How do you use version control with Access development?
  4. What are the rules governing usage of parenthesis in VBA function calls?
  5. Autonumber value of last inserted row – MS Access / VBA
  6. Microsoft Access condense multiple lines in a table
  7. Code to loop through all records in MS Access
  8. create form to add records in multiple tables
  9. Operation must use an updatable query. (Error 3073) Microsoft Access
  10. How do I force VBA/Access to require variables to be defined?
  11. Why is my query not updateable?
  12. Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
  13. Is it possible to create a recursive query in Access?
  14. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  15. What is the equivalent of Select Case in Access SQL?
  16. Equivalent cURL in VBA?
  17. How do I access the selected rows in Access?
  18. insert query with sequential primary key
  19. How do I execute multiple SQL Statements in Access’ Query Editor?
  20. VBA procedure to import csv file into access
  21. How to select top 10 in Access query?
  22. how to show query results in a datasheet in the same form?
  23. Selecting 2 tables from 2 different databases (ACCESS)
  24. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  25. MS Access prepared statements
  26. Linked table ms access 2010 change connection string
  27. Create sequential ID value based on the year that a record is added
  28. How to use cross join in access?
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment