View Full Version : between two dates


deepbreath
07-18-2001, 04:49 AM
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

DJN
07-18-2001, 05:24 AM
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.