I've a simple query which extract some records according to a DateTime field.
I can't explain why but with some dates it doesn't work (null result).
It seems that it doesn't work with first days of month while it works with last days (10th and above).
In the example above it doesn't work with #04/09/2016# while it works with #09/09/2016#!
Could it depend on Date Format?
In SQL view the date is always written
#mm/dd/yyyy#, even if in the design view it is
#dd/mm/yyyy#. So your SQL is requesting April 9. Is that your intent ?