Date filter

[Fabian1675]

Hello everyone, I got a quick question to the experts

I have a form that has 3 textboxes named: StartDate, EndDate and Name. What I'm trying to do is have the user enter a start and end date then the name then click the search button, when I click on the button it does not return the date specified from the textboxes. it just displays all the record for the name that was selected.


This is what I wrote in my querry under StartDate criteria section:

between [forms]![datesearch]![StartDate] and [forms]![datesearch]![EndDate]

I'm not sure why this is not filtering the proper dates.

 

[Brianwarnock]

What is the full SQL Where clause

Brian

 

[Brianwarnock]

Just realised that you have 2 date fields,
Under startdate<= yourformfield
Under enddate >= yourformfield

Brian

 

[MStef]

Look at "DemoStartDateEndDateA20022003.mdb" (attachment, zip).
Look at Table, Query, Form.
Open Form1 and try.
Adapt it in your mdb.