between two dates or for one date

[kaveman]

I want to be able to run a query that will prompt for a start date and an end date using "BETWEEN [Enter Start Date] AND [Enter End Date]" for my date field. At the same time if the user only wants to view one days worth of data I don't want them to have to enter the date once when the Start message box is displayed and then again when the End message box pops up I want them to be able to enter the date only once and then click "OK" on the next box. Is this possible?

 

[daveUK]

Use a form, which has 2 option buttons. One, which allows the user to enter 2 dates and the other, which just has one textbox for the date. Have a cmd button on the form, which runs a query to display the results.

I've attached a rough and ready example to show you what I mean.

 

[kaveman]

Thanks a whole bunch this works great and I am able to apply this to many queries/reports. This will save a lot of frustration on the users part.