Validation Rule

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

Guest

In Access 2003 how do I set up this databse rule? If Field A equals the
value "West", then Field B can only equal the values "Sam" Or "Bob".
 
Open your table in design view.
Open the Properties box (View menu).
Beside the Validation Rule for the table, try:
([A] Is Null) OR ([A] <> "West") OR ( IN ("Sam", "Bob"))

The rule is satisfied if A is blank or something other than West.
Otherwise the only way it can be satisifed is if B is one of the value
listed.

Note that the table's rule (in the Proprties box) is not the same as a
field's Validation Rule (in the lower pane of table design.)
 
Back
Top