Newbie...Date Criteria

  • Thread starter Thread starter Jeff
  • Start date Start date
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
 
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:]
 
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.
 
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...
 
Back
Top