On Thu, 4 Dec 2008 06:10:00 -0800, blendes <blendes[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >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.
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.
--
John W. Vinson [MVP]
|