query for random records

[_Bigred]

Is there a way to pull up random records using a query?

I am creating a guitar practice database, and would like to pull up random
records contained in the db.

Would like to set this feature to a report and then other buttons also.

TIA,
_Bigred

 

[Guest]

Put something like this in the field of a query:

RandomRecords: Rnd(IsNull(asa.AsaID)*0+1)

Change "asa" to the name of the table and "AsaID" to the name of a number
field. Sort on RandomRecords.

 

[_Bigred]

Thanks Jerry.

Put something like this in the field of a query:

RandomRecords: Rnd(IsNull(asa.AsaID)*0+1)

Change "asa" to the name of the table and "AsaID" to the name of a number
field. Sort on RandomRecords.