How do I run a query that returns a random result in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to generate a monthly random name draw from an access database.
I can filter the query to isolate a given time frame, but I would like to
randomly draw a winner from the query. Although I have fairly good access
knowledge, I have limited SQL, and VBA knowledge. Any assistance would be
appreciated.
 
Scott R said:
I would like to generate a monthly random name draw from an access
database. I can filter the query to isolate a given time frame, but I
would like to randomly draw a winner from the query. Although I have
fairly good access knowledge, I have limited SQL, and VBA knowledge.
Any assistance would be appreciated.
Click to expand...

Check out this article:

http://www.mvps.org/access/queries/qry0011.htm
Queries: Create a query that returns Random records

If that's not clear enough, post back.
 
Back
Top