Please post some data from the date fields. Access can get freaky when the dates take formats like YYYY-MM-DD, etc. SO if you date fields are not what Access is expecting, it won't return any records, or the wrong records.
One solution I use is to use a combo box to look up the dates as they are formatted, and then use them as strings to get the data filtered.
HTH
mmcdonal
|