Need help on my SQL statement with date criteria

[jmcilhinney]

jmchilney, Access can display the time portion too.

I didn't say that it couldn't. What I said was that your setting the properties of a column to display only the date portion doesn't mean that it doesn't have a time portion.