Hello, Diana. The date ranges you are trying to set are not valid dates. A date (in USA format) is defined by a month, day, and year (usually expressed mm/dd/yyyy).
You said "Oct-2007". That is not a date. First, you have it in quotes which make it a string. Second, you only have a month and year but no day. Valid date ranges (in USA format) are, for example:
[StartDate] Between #10/1/2007# And #10/31/2007#
[StartDate] < #10/1/2007# and [EndDate] > #10/31/2007#
The pound sign # is the delimiter for the DATE data type.
Michigan Dept. of Environmental Quality, Air Quality Division