Query By Date

[Tara]

I have a query that calculates how much time a person has spent at various
tasks. The query is limited by a start date and an end date as the criteria
of the field ContactDate. It works fine right now, but I want to take it a
step further and make it so that users can't set the start date earlier than
01/01/2009. I still want them to be able to set it to any date AFTER that
date too though.

Any ideas?

Thanks!

 

[Jerry Whittle]

At table design level create a validation rule for that table like so:

=#1/1/2009#

In the Validation Text box put something like:
Date must be after 1/1/2009

Access will probably complain about existing records after you save the
table changes. Just click Yes and it should still work OK for new records.