Query By Date

  • Thread starter Thread starter Tara
  • Start date Start date
T

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!
 
At table design level create a validation rule for that table like so:
=#1/1/2009#
Click to expand...

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.
 
Back
Top