ScottBeatty
Registered User.
- Local time
- Today, 11:07
- Joined
- May 31, 2013
- Messages
- 65
Hi all. I have a scenario that I've been working on but need some help. I have a query that contains about 2000 records and each record has one of the 50 states attached to it. What I'd like to do is randomly select 2 records and export that record into a report. In addition, I was wondering if it was possible to have no duplicates until all of the states were selected.
I've been trying to use the Rnd() function in the design view for the corresponding ID to the record but I don't really know what to put in the parenthesis for the query to yield what I'd like it to.
Any help would be great. Thanks a lot!
I've been trying to use the Rnd() function in the design view for the corresponding ID to the record but I don't really know what to put in the parenthesis for the query to yield what I'd like it to.
Any help would be great. Thanks a lot!
