Validation Rule

C

CP

I have the following validation rule attached to a field in a table.
[HRA Directory]<>"CLI"
Is there a way to add more criteria to it, such as in addition to CLI ( or
"ABC")? I was not able to get it to work.
 
S

Steve Schapel

CP,

Normally a field-level Validation Rule would not include the name of the
field. You would just put like this...
<>"CLI"

In the other example you gave, try it like this...
<>"CLI" And <>"ABC"

This may also work...
Not In("CLI","ABC")
 

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

Top