multiple validation rules in tables?

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

How many validation rules are allowed in a table and how to separate each of
them? Moreover can this be used [lname]<>[fname]? Thanks
 
How many validation rules are allowed in a table and how to separate each of
them?
Separate them with an 'OR' like this - >15 AND <20 OR Between 5 AND 9
Moreover can this be used [lname]<>[fname]?
Did you try it? Why not try it? Validation is placed on a field in the
table so if you are validating field [lname] you would enter <>[fname] in
the validation properties of the field.
 
You must log in or register to reply here.

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

Combine related records into flat file 6
Creating a report with calculated fields 3
Join two tables 2
Set validation rule for many fields with vba? 7
Append Query 2
Access Validation rule of 1 field based on a field of another table 1
split data in 2 new fields 2
Method or Data Member not found 3

Back
Top