validation rules

L

Laverne

I am trying to enter an expression that would only allow dates between 6/1/2001 and 9/30/2001 to be entered into the database.Any tips or suggesstions????
 
R

Roxie Aho

In the text box on your data entry from, type the
following into your Validation Rule property:
#5/31/2001# And <#10/1/2001#. Type an appropriate
Click to expand...
message in the Validation Text property.
Roxie Aho
-----Original Message-----
I am trying to enter an expression that would only allow
Click to expand...
dates between 6/1/2001 and 9/30/2001 to be entered into
the database.Any tips or suggesstions????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign Values Based on First Record in Group 2
I need to place a rule between columns 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Comparing dates 1
Space at end of multi page list to accommodate new entries 1
Validation Rule 2
Project Start and End Date is not consistent 1

Top