Date

[Sergei]

In my select query (Access 2003) I need to set the criteria in the date field
to limit it to the range. What would be the exact string to set the range
between 1-1-09 and 12-31-01?

Thank you!

 

[Daniel Pineault]

Date literals need to be enclosed in hashes, as shown below:

Between #01/01/09# And #12/31/09#
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

Date literals need to be enclosed in hashes, as shown below:

Between #01/01/09# And #12/31/09#

Note also that if you use literal dates they must be in the American
(month/day/year) format, or an unambiguous format such as #2009-01-26#.