By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,943 Members | 1,530 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,943 IT Pros & Developers. It's quick & easy.

Need help with ValidationRule

P: n/a
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

Dec 14 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Dec 14 '05 #2

P: n/a
Works!

Thank you

Dec 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.