between two dates

deepbreath

Registered User.
Local time
Today, 19:50
Joined
Apr 18, 2001
Messages
73
i want to build a search form to find all records between two dates, e.g between jan-march, etc. can someone plz show me in details steps
thanks
 
Create an unbound form with two unbound text boxes. Name them txtBeginDate and txtEndDate. In the criteria line for the date field put this: Between [forms]![frmYourSearchFormName]![txtBeginDate] And [forms]![frmYourSearchFormName]![txtEndDate]
Now just add a command button to run the query and after clicking on the button you should see the results.
 

Users who are viewing this thread

Back
Top Bottom