If Date1 and Date2 are fields in the same table, you can do it with a
table-level validation rule. To create a table-level validation rule, open
the table in design view, and choose Properties from the View menu. Enter an
expression such as ...
[Date2] >= [Date1] in the Validation Rule field, and enter the text you want
to display when the user attempts to enter data that would break this rule
in the Validation Text field.
--
Brendan Reynolds (MVP)
DianaS said:
Hello,
I would like to restrict [Date2] in the following way:
[Date2] is greater than or equal to [Date1].
How does one do this?
Thank you,
Diana