Newbie...Date Criteria

J

Jeff

Hello. I have a query with a submission date variable
and want to be able to prompt the user to enter a start
date and end date to retrieve a specified range of
records. How do you go about doing this in the design
view criteria field? Thanks in advance.

Jeff
 
K

Ken Snell [MVP]

Use a criterion expression similar to this (the parameter prompts result
from the text in the [ ] characters):

Between [Enter the start date:] And [Enter the end date:]
 
S

Steve

Copy this into your criteria field;

Between [Enter Start Date] and [Enter End Date]

Valid dates will need to be provided for it to work
properly.

Regards,
Steve.
 
J

Jeff

Thanks Steve. I was missing the between portion of the
expression. Opps. lol

Jeff
-----Original Message-----
Copy this into your criteria field;

Between [Enter Start Date] and [Enter End Date]

Valid dates will need to be provided for it to work
properly.

Regards,
Steve.
-----Original Message-----
Hello. I have a query with a submission date variable
and want to be able to prompt the user to enter a start
date and end date to retrieve a specified range of
records. How do you go about doing this in the design
view criteria field? Thanks in advance.

Jeff
.
Click to expand...
.
Click to expand...
 
Top