trying to put a 'between date' criteria like this in the build function:
Between #11/28/2014# And #11/29/2014#
but after I 'ok' the build, it gets saved as:
Between "#11/28/2014#" And "#11/29/2014#" .. the quotes get added
then the query does not work, because
it thinks its a string search due to the quotes?
I even tried >=...<= instead of between and quotes got added there too!
Access has a mind of its own?