Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to chose "random" records from table. 3

Status
Not open for further replies.

Louise99

Technical User
Sep 13, 2004
70
US
I need to have a set of random records with the criteria of a month start and end date. Can I do this in Access with VBA? I know that Excel has the RAND()function but I would like to be able to get my records right in the Access database.

Any ideas?

Thanks

Thanks!
 




Hi,

I'd return a recordset based on the set criteria and then apply the random function to that number or rows.

Skip,

[glasses] [red][/red]
[tongue]
 
You may use the Rnd function with a numeric field as argument in your query and sort by this column.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top