Selecting records within a date range

  • Thread starter Thread starter Kristibaer
  • Start date Start date
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.
 
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
 
Back
Top