Question Searching via dates

[knightjp]

Hey guys,

I'm very new to access. I trying to make a database of our company staff.
I want to be able to enter certain dates like, "08/01/2008" to "09/09/2008" and have my database display the strings that have the dates in between.
Any ideas on how this can be done???

 

[tarcona]

Hello,

First you have to create a query and include all the information you want. Include the date fields.

Then you have to create a form based off the query. Create two text boxes for Date (From) and Date (To). Then create a button to open up the query. That is it.

Well, sorry that is not it. Ha. In your query you have to fiddle with the criteria portion.

If you want to send me your database I can quickly make a "sample" date search. I use Access 2000 so do any conoverting if you need to.

 

[tarcona]

But basically for the criteria in the query, under the Date (From) you put:

>=[Forms]![FormName]![txtDateFrom]

and then you put this under your Date (To):

<=[Forms]![FormName]![txtDateTo]

FormName = Your form name
txtDateFrom = the name of the text box that you created in the form for your Date (From)
txtDateTo = the name of the text box that you created in the form for your Date (To)