I'm going nuts (validate field)

[lbonsemb]

Hi,

Can somebody tell me how to validate a field with a formula that includes the MOD operator? I tried to validate on the table but later read that the MOD operator is not accepted.

Thanks for your help,

Luis

 

[tlbroadbent]

MOD is available in Access and in Jet Queries. It is the modulus operator and you would use as follows.

Example: Select all rows where ID is a multiple of 3.

Select * From Table Where ID Mod 3 = 0 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.