Select Between Two Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to create a query to select dates that are between date 1
(1985-11-04) and date 2 (1985-11-11). Currently no records are showing up
when I do this:
Between (1985-11-4) And (1985-11-11)

I've checked and made sure that there is at least one record that meets all
specified criteria. Any help would be appreciated. Thanks,
jay_2882
 
Try... Between #1985-11-4# And #1985-11-11#

If your dates are in variables, use the DATEDIFF function (look up in Access
Help)

-Dorian
 
Back
Top