every 10th record

[blendes]

I have a database for parts that are being tested. What i need to so is set
up the database to have the database only allow the users to do one test
every tenth unit. I am struggling on how to do this. The way i was going to
do it was set a counted on the number of new parts numbers they enter. I can
not get it to work correctly. I am wondering if anyone has a idea on how to
do this.

 

[Arvin Meyer [MVP]]

If you have a sequential autonumber, you could do something like this in a
query:

SELECT *
FROM tblMyTable
WHERE ((([ID]/10)=Int([ID]/10)));

 

[KARL DEWEY]

Post your data structure and sample data.

 

[KARL DEWEY]

If you have an autonumber field then try this --
X: [AutonumberField] Mod 10
Set criteria 0 (zero).