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!
