Select Between Two Dates

J

jay_2882

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
 
M

mscertified

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF update query with Between Criteria 6
Issue with OLE DB Query - Date Search 0
Update query with date criteria 3
Lookup between two dates 3
Using between function with General Date 4
query for dates 2
Select data and sum by weeks in a month 3
Time Between the Time of the Current Record and the Next Earliest 8

Top