Need to chose "random" records from table. 3

[Louise99]

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!

 

[SkipVought]

Hi,

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

Skip,

_[red][/red]

 

[PHV]

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

 

[AnotherHiggins]

FYI: Access' version of the Rand() function is the Rnd() function.

For more details, see
ACC2000: Find N Records in Random Order

Specifically to answer your question, see
ACC2000: Sample Function to Return a Random Record from a Field

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.