Forum home » Delegate support and help forum » Microsoft Access Training and help » Validation of dates
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Validation of dates
Resolved · Low Priority · Version 2007
Reply Thu 4 Dec 2008, 16:50Delegate Julie said...
Julie has attended:
Access Introduction course
Access Intermediate course
Validation of dates
how do you set the data up so that you cannot enter a delivery date that is before the order date?
For upcoming training course dates see: Pricing & availability
RE: Validation of dates
Hi Julie,
Thank you for your question.
If you go into design view of the table and click into the Validation rule property field.
Type the following: >date() - which means greater than the current date.
Now type the Validation text to explain the rule.
Alternatively you could set up a query and add a calculated field that works out the delivery date.
E.g. DeliveryDate:[OrderDate]+7 - If the delivery date was always 7 days later.
I hope this answers your question.
Regards
Simon
|