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
thanks
|
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. |