Validation Rule

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

Guest

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.
 
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

Similar Threads

Access Validation rule of 1 field based on a field of another table 1
Validation rule for Combo Box 0
Query Design 1
Validation Rules for a Control on a Form (?) 4
Validation Rule assistance 0
Is there some guideline for the CLI wrapper for C++ code? 1
The various levels of /CLI 2
Excel Help with auto-forwarding calendar invites in Outlook! 0

Back
Top