Solved: How to pick a specific random records from a query?

[winxmun]

Hi Morning,

May I know how to randomly pick up some of the records from a specific period?

Currently I manually run the query with the period and export out the data to excel. Thereafter randomly delete the records manually. This is very tedius as the total record is about 3000 but i just want 30 records from there only.

:help
Thank you in advance!

[orange]

See this
http://www.techrepublic.com/blog/howdoi/how-do-i-retrieve-a-random-set-of-records-in-microsoft-access/149

[winxmun]

thanks for the link. I will try.

[winxmun]

Hi Orange,

It works perfectly fine! Thanks for the link.
btw, i found this link very useful as well.

http://www.databasedev.co.uk/random_query.html