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?
Sat 6 Dec 2008, 11:52Trainer Simon said...
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
