Selecting records within a date range

[Kristibaer]

What would be the proper expression to display records only between a
specific date range? <#12/31/2006# Or >#1/1/2008# in the criteria field isn't
filtering the data.

 

[Jerry Whittle]

Between #12/31/2006# and #1/1/2008#

That should return any records including those dates; however if the January
1, 2008 date also has any time stored in it, those records won't show.
Something like below will work:

Between #12/31/2006# and #1/1/2008# + .99999

 

[Jeanette Cunningham]

Kristibaer,
replace the OR with an AND
swap the greater and less than symbols

=#12/31/2006# And <=#1/1/2008#

Jeanette Cunningham