Select Query

[PBear]

Hi, I have a table with employees names. I understand how to do a query that selects random 10% each month to take part in a test. However, I am unable to figure out how to keep those employees from being selected again as each employee is only required to participate once annually.



Would appreciate any ideas. Thanks in advance.

[June7]

You have a table of all test dates and which employees participated? Or not maintaining history?
Need a field with date of test. Exclude employee if date of last test is less then 1 year ago.

[PBear]

I wasn't planning on keeping a record of the last test taken as that date would be recorded in their employee file.

I have now created the date of test field and am trying to figure out how to exclude the record once filled (Any idea on how to auto-fill that field on selection???).

[PBear]

June7, Thanks for the idea.

I added a date field to keep track of when the employee was selected. I also added a yes/no field which would be checked true when the employee was selected. The query now only selects from the employees unchecked. At the end of the year I can go back in and delete all the dates and start over again.

Thanks for your help