Microsoft Access Search

[dexthageek]

I am trying to search my database to display results depending on date.

Example.. From 3/01/02 To 3/30/02

I know how to do it in a qry but i want users to be able to enter the ranges into a text box and then run the search from a command buttom.

 

[mdthornton]

Have you tried something like this in your criteria line for your date field:

Between [Enter Start Date: ] and [Enter End Date: ] Best Regards,
Mike

 

[dexthageek]

Thanks.

That worked perfect a friend of mine told me about this site and he was right its great.

Thanks again

Mike Mazza