Selecting records within a date range

K

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.
 
J

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
 
Top