Access Database Date Filter not working..

[si_the_geek]

Replace the ( ' ) with ( # ) when using BETWEEN clause in Microsoft Access.

That change is not good enough - the format also needs to be set appropriately, otherwise the value will be interpreted incorrectly at times (especially true if the Regional Settings date format is not US or ISO).

For more information, see the article How can I work with dates correctly? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)