C
C. Hernandez
I am creating an IIF Statement in the Validation Rule property of a field
(Field A). I need it to provide the Validation Text based on a calculation in
another field (Field B). If [Field B] is between 0.01 and 0.99, then give the
Validation Text, if not then do nothing and let the users move on.
This is one of the many statements I've tried:
=IIf([Field B] Between 0.01 And 0.99,Between 0.01 And 0.99,0 Or 1)
Regards,
~ Chris
(Field A). I need it to provide the Validation Text based on a calculation in
another field (Field B). If [Field B] is between 0.01 and 0.99, then give the
Validation Text, if not then do nothing and let the users move on.
This is one of the many statements I've tried:
=IIf([Field B] Between 0.01 And 0.99,Between 0.01 And 0.99,0 Or 1)
Regards,
~ Chris