Question about changing a query value without going into design view

[Soulbait]

I have some queries set up but I would like for the users to input 2 date ranges in say a form and that would be the criteria for the query, can anyone tell me how this would be done?

Thanks

 

[Max1mum2]

Try putting

Between [Start date] and [End Date]

into your criteria section for the date field you want to search between. When you run the query it should pop up 2 input boxes for Start Date and End Date

let me know if this helps.. there are many ways to do this, but this is the easiest

- maximum

 

[Soulbait]

That'll work perfectly, thanks.