One issue I had quite a while back was Access Reports with records filtered between two specific dates (dd/mm/yyyy) but with extra entries appearing outside of the specified dates on the report.

This was happening because by default Access also includes the time along with the date in a date field:

I had started by [...]