Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
validation rules

ResolvedVersion 2007

Julie has attended:
Access Introduction course
Excel Introduction course

Validation rules

How do I condition my table so that my delivery date cannot be before my ordered date?

RE: validation rules

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.

I hope this answers your question.

Regards

Simon

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.