Start & End Date Query

[batowl]

I have a very simple database comprised of one table. There is an event date field within the database that my end users want to query on. They would like to be able to specify a beginning date and an end date and pull up all records that have an event date between these two values.



I realize it is quite easy to do that in a query, but I need the interface for this query to be very simple and easy (the users do not want to be in design view of the query typing in dates). So is there a way to build a query so that the users specify their date range for the query on a form by typing a beginning date in one field and an end date in another field? Thanks.

[pbaldy]

Yes of course, that's the most common setup. Generally the form would have the two textboxes plus a button to open the form/report the query is being used for. The query criteria would look like:

Between Forms!FormName.FirstTextbox And Forms!FormName.SecondTextbox