every 10th

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

blendes

I am working on a database where right now they have to fill in a specific
part of a form that relates to a test. I am trying to make the database only
ask for them to collect that data every 10th unit. I can not figure out a way
to make this work. I would greatly appreciate any help that anyone can give.
 
I am working on a database where right now they have to fill in a specific
part of a form that relates to a test. I am trying to make the database only
ask for them to collect that data every 10th unit. I can not figure out a way
to make this work. I would greatly appreciate any help that anyone can give.
Click to expand...

Since you chose not to post any information about your table, or your
definition of a "unit", all I can suggest is that you look at the MOD
operator. It returns the remainder after a division, so an integer field MOD
10 will be the last digit; if your "unit" is a number value and you want to
return only those values that are multiples of 10, use

[Unit] MOD 10

as a calculated field with a criterion of 0.
 
Back
Top