Software

Ask something
Discussion Locked

Access 97 - Random Sample

0 helpful
3 replies

by chainsawz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Access 97 table that contains two fields: document number(unique number), and processor's initials. This table is refreshed with new records every day, and the file size can vary from day to day. I need an automated process to pull a random 5% sample from the table each day. Does anyone have VB code, or some other process to accomplish this? Please be detailed in your answer.

Thanks in advance!

3 replies

by dklippert

There is an article by Microsoft that details the procedure. It was written for Access 97. Go to technet.microsoft.com and type Q170986 in Search box.

This discussion is closed to new replies.