Date Query

[phillsheen]

Hi,
Can any one tell me how to create a query that will allow me to view data between two dates. For example I need to see payments between 01/06/06 and 12/06/06.
I would like it to come up with an input box also so the user can input the dates in with out editing the query.

Any help would be rockin!
Cheers

Phill

 

[ColinEssex]

In the criteria line of the query under the date field put this

Between [Enter Start Date] and [Enter End Date]

Now run the query, you will be prompted for the dates

Col

 

[Michael J Ross]

Create a query and in the criteria under your date field enter Between [Enter Date From] And [Enter Date To]

This will search between the two dates the user will enter in a pop up (parameter) box that appears when the query is run.

 

[Tony1258]

if you are using a form you can set up two date fields using text boxes one for the begin date and one for the end date. In your query you can refer to the text boxex with a between function to capture the data.

between Between [forms]![form name]![begin date] And [forms]![form name]![end Date]

This will allow you to put in the dates on a form to selec the data.

hope this helps

Tony