ScottBeatty
Registered User.
- Local time
- Today, 01:12
- Joined
- May 31, 2013
- Messages
- 65
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
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