Random selection from large data set

[ScottBeatty]

I have a question about something on my database that I do not even know if it's possible or not, but I figured it's worth a shot.

I pulled a report from this website my company uses and it has around 7,000 orders and a corresponding employee to each record. Since each employee has around 20-50 orders, I was wondering if there was a VBA code or different Access tool to randomly select only 2 orders from each employee, thus reducing the data set from 7,000 to a more manageable number?

Any help would be much appreciated. Thanks

Scott

 

[rzw0wr]

Try the Rnd(number) function.

Dale

 

[DavidAtWork]

Look in the help for the Rondomize statement, it's quite straightforward to use, you just need to think how you can apply a randomly generated number as way of selecting an order

David

 

[Mihail]

Can you show as the structure ? Tables, Fields, Relationships ?
I'm pretty sure that that can be done.

 

[jdraw]

Here is a link to sample code and description of Random numbers with Access
http://www.techrepublic.com/blog/ho...random-set-of-records-in-microsoft-access/149

Good luck with your project

 

[smithdavid]

Use Rnd(FieldValue) function to retrieve random values.