What Criteria to enter for a field "Service Date" and filter by this date and after?

[Daniel B]

I have a query that contains a "Service Date" field. I would like to form a Criteria statement to be able to enter any date (such as... 1/1/2011). I would then like to be able to run the query and see values between the entered date (1/1/2011) and the current date.

Is there a way of doing this by enter in the Criteria for the "Service Date" field?

Any help is much appreciated!

Daniel B.

[Narender Sagar]

Hi Daniel,
You can create a Form ("Dialog"). Create two Unbound fields in the form : 1. "BeginningDate" and 2. "CurrentDate". Set default value of "CurrentDate" as Date(), and you can choose any date for your field BeginningDate .
Now you can create a query and in the criteria you can give following expression: Between [Forms]![Dialog]![BeginningDate] And [Forms]![Dialog]![CurrentDate]. So you will get result as you required. You can even write some VBA codes for more controls (Like users should not be able to select date which is in future or some other checks like that..

[Rabbit]

In the criteria, you can put

BETWEEN CDate([Enter Start Date]) AND Date()

[Daniel B]

Thank you Mr. Rabbit, I was really hoping it was something simple like that!

Daniel B

[NeoPa]

There is absolutely nothing wrong with Rabbit's answer, but maybe the question could do with some attention.

Assuming all the values in the table for [Service Date] reflect historical (and current) dates - IE. None are future dates - as would appear reasonable, why is the question not about finding [Service Date]s on or after a specified date?

[Service Date] >= [Enter Start Date]