Query Quality Control Issue

[ittech70]

I am moving from Filemaker to Access and want to create a Quality Control query to flag every (nth) record as it is created to require the individual to perform the quality control process. I have done this in Filemaker as a script, but not sure how to do it in Access. Any help would be greatly appreciated,

[TheShabz]

Storing a flag like that in a table isnt really the best idea. What I would do is whenever a QC needs to be done, to run a query that pulls a random set of records to be checked.

pulling random records is described in the link. Hope it works out
http://www.databasedev.co.uk/random_query.html