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

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.