First timer

[douglas06]

Selecting Date ranges??

Can someone help me, I have a date field in an access program I have written. I want to write a query which will enable the user to enter a range (start date then end date) and the query will only show records in that range.

Thanks.

 

[Rob519]

In the 'Date' criteria field on your query, put in:

Between [Start Date] And [End Date]

When you run the query, it should now ask you for a start date, followed by an end date. This should solve your problem!