And depending on whether your range is INCLUSIVE or EXCLUSIVE, you might need
d1 >= d2 and d1 <= d3 (double-ended inclusive).
A word of warning: date fields, depending on how they were stored, MIGHT include times as well as the date part, and might make you wonder why two dates that print as the same date are nonetheless not equal. The answer would be that if raw date fields were stored using the Now() function to supply the timestamp, they WILL include times. Whereas if you used the Date() function to supply the datestamp, they will not.
I don't want to confuse you further unless you need more information on dates and times in Access.