Between dates

[sislman01]

Hi,

I need to look at data where a date falls between two dates.

i.e. I might want to look at sales made between 01/01/2005 and 01/12/2005.

Im new to Access and know that you can use BETWEEN but not sure how to write the query.

Thanks

 

[Len Boorman]

Different ways can be used but one way is to put into the criteria of the query

Between [Please Enter Begin Date] and [Please Enter End Date]

This will prompt the user for the dates to be considered.

L

 

[sislman01]

Thanks Len,

How do I combined this in a WHERE query. I would like to say WHERE a date falls BETWEEN date (a) and date (b) then show the data.

Also do I show dates as 01/01/2005 or 01012005?

Regards

 

[Jibbadiah]

Between #01/01/2004# And #01/10/2005#

If you put that in the Criteria section of an Access query it should automatically add the hash (#) signs if the fields are date format.

 

[neileg]

Just to clarify, a basic query in the design grid is a SELECT query. Adding a criterion adds a WHERE clause to the SQL. You can look at the SQL by chosing SQL view in the query design window.