Parameters

[bpifer23]

This seems like this problem should be easy to fix. What i am trying to do is to have my query show the users selected date range. I keep running into problems with this, I figured that a parameter would be the easiest thing to do as it prompts the user for the dates that they need. The table field is called actual ship date. But I am having problems writing the parameter correctly (I assume).

Any insight to this would be great.

Thanks!!!

 

[THWatson]

Two options...
1. If you want to run the parameters from your query, in your Date field column enter this criteria
Between [Enter Start Date] And [Enter End Date]

2. The other way is to have a form on which there are two text boxes, one to select the StartDate and the other to select the EndDate. Say the form is called frmSelectDates, and the text boxes are called txtStartDate and txtEndDate.
Then, in your query, enter this criteria in your Date column...
Between Forms!frmSelectDates!txtStartDate And Forms!frmSelectDates!txtEndDate

Tom