Comparing two fields in a table

  • Thread starter Thread starter Wolff
  • Start date Start date
W

Wolff

How do you compare two fields in a table for instance you want to
compare two date field such that Date1<Date2 what do you type in the
validation rule box. I have tried <Date2 which doesn't work and
<[Date2] gives me an error.
 
How do you compare two fields in a table for instance you want to
compare two date field such that Date1<Date2 what do you type in the
validation rule box. I have tried <Date2 which doesn't work and
<[Date2] gives me an error.
Click to expand...

Validation Rules cannot contain references to forms, tables, or other
fields in the table. Put the validation code in the BeforeUpdate
event instead.
 
Back
Top