Query String

[mattpv]

I have a query that makes a report. Can I insert a string for the "Date we shipped" data field criteria that makes the user enter a start date and a end date. This will create a report for the period between those two dates.

I know I could have the user enter on the criteria line for that data field "between 01/01/01 and 01/31/01". I would perfer to have a start date parimeter value box and end date box that tehy could just enter start date and end date. I appreciate all the help!

 

[jhall156]

In your query designer in the criteria for the date put >=[Enter Beginning Date] then insert a new column next to it with the same field, uncheck the &quot;Show&quot; check box and in the criteria put <=[Enter Ending Date] JHall