Urgent-help!! Simple Date Query

[StacyStacy]

How do I write a statement in my query to pull records from a certain timeframe.

Ex: between 7/1/2000 and 6/30/2001

Thanks.

 

[StacyStacy]

I Got It!!

Here's how to write it!

#7/1/2000# And "«Expr»"<#6/30/2001#

 

[Ally]

From what you've written I would have thought that it would only return dates from 7/1/2000 dates from 6/30/2001.

The correct syntax would be:

Between 7/1/2000 and 3/30/2001

Access will automatically add the # around the dates.

 

[StacyStacy]

Thanks.

Thank you. I will modify the statement.
-StacyStacy