date parameter prompt - 1 for beginning 1 for ending?

[taylornow]

Hello everyone. Have a database with date field showing date inspected - DATESURVEYED -. I need to fix the query so they can put in a beginning date and then an ending date. I have a query with a parameter box pop up for a single date but not a range. Need it as simple for them to enter as possible.

As always - thanks in advance.

Taylor

 

[GoDawgs]

Not sure how to do it in one step, but you can have two input boxes pop up...in the criteria where you already have the one variable that causes the parameter box to pop up add another variable...something like this:

>=[Enter Beginning Date] and <=[Enter Ending Date]

That will give you a parameter box for each of those with easy to understand instructions. Hope that helps.

Kevin

 

[taylornow]

Thanks so much - I will give it a go.

Taylor