every 10th record

  • Thread starter Thread starter blendes
  • Start date Start date
B

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.
 
If you have a sequential autonumber, you could do something like this in a
query:

SELECT *
FROM tblMyTable
WHERE ((([ID]/10)=Int([ID]/10)));
 
If you have an autonumber field then try this --
X: [AutonumberField] Mod 10
Set criteria 0 (zero).
 
Back
Top