How do I set up the MOD function as a validation rule?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope someone out there can answer this for me.

I have been trying to set up the MOD 7 as a validation rule but I can't make
it work.

I would be very thankful for any assistance given. Thanks.
 
Mod is an operator, so it should be possible to use a validation rule like
this in MyField:
[MyField] MOD 7 = 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up the MOD expression as a validation rule? 11
Set validation rule for many fields with vba? 7
Validation Rule using data between two different tables 4
Access Validation rule of 1 field based on a field of another table 1
correct syntax for MOD in the validation rule 6
Excel Repeating a RAND() function under certain conditions 0
multiple validation rules 3
Validation Rules for a Control on a Form (?) 4

Back
Top