Validation Rule

[Madhup Thakur]

Access 2K

I am trying to set a Validation Rule for date field say ExitDate to be later
than EntryDate by typing in >"EntryDate" Or Is null. But no entry seems to
be passing the validation. Any clues to why is not working.Thanks

M. Thakur

 

[Wayne Morgan]

To the best of my knowledge, you can't enter a validation rule in a field
that refers to another field. However, if you right click where the field
entries are in table design mode and choose Properties, you can enter such a
validation for the table. I just tried the following and it worked as
expected.

[ExitDate]>[EntryDate] Or [ExitDate] Is Null

Since you only have one of these available for the whole table, you may find
it easier to use the BeforeUpdate event of a form or controls on a form to
verify the data, especially if you're going to need multiple, cross-field
validations.

 

[Madhup Thakur]

Thank you so much.
M. Thakur