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

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.
 
D

Dirk Goldgar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Selection in Access 5
Select query returns a different result in Access and Access-VBA 7
Send filtered result to existing report 1
Non Uniform Random Number Generator 2
How does one eliminate blank records on a query result? 3
access 2002, run a query to update a form field when button isclicked? 3
How do I generate a random selection query in Access? 1
Random Top 10 percent of groups 6

Top