Query from one date to another 1

[davidodell]

OK you guys and gals are great but here is another one what is the easiest way to query from one date to another. Like from 09/01/2003 through 09/30/2003. Or is there an easy way to set it up where you can prompt to enter the dates to query?

Thanks
David

 

[dodge20]

In your query if you want to prompt for a date then it would be something like

..
where YourDateField between [Enter Start Date] and [Enter End Date]

Dodge20

 

[GoDawgs]

If the dates are set then you just need to put that criteria into the query itself...something like this:

between #9/1/2003# and #9/30/2003#

If you want the user to enter the data something like this should work:

Between Format([Start Date],"mm/dd/yyyy&quot And Format([End Date],"mm/dd/yyyy&quot

You could also use a Form and call the text boxes on the Form from the query instead of using [Start Date] and [End Date]. Hope that helps.

Kevin

 

[dodge20]

GoDawgs answer is better than mine. I forgot the format.

Dodge20

 

[davidodell]

That works perfectly thanks to both of you!