Need help with ValidationRule

[Lebowski]

How ValidationRule for data/hour field should I formulate if I wanted
that date to be prior/earlier than another date in other data/hour
field in the same table?

How syntax/notation about referencing to other fields looks like?

thanks, bart

[Allen Browne]

Open your table in design view.

Open the Properties box (View menu.)

Beside the Validation Rule in the Properties box, enter:
[EndDate] >= [StartDate]
substituting your fiele names.

Notes:
1. The Validation Rule in the Properties box is the table rule, applied at
record-level. It is different from the rule in the lower pane of table
design (which is a field-level rule.)

2. In older versions of Access, the rule above has the side effect of making
both fields required. You might want to use:
([StartDate] Is Null) OR ([EndDate] Is Null) OR ([EndDate] >=
[StartDate])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lebowski" <bd*******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

How ValidationRule for data/hour field should I formulate if I wanted
that date to be prior/earlier than another date in other data/hour
field in the same table?

How syntax/notation about referencing to other fields looks like?

thanks, bart

[Lebowski]

Works!

Thank you