Hi all,
I am trying to do something I thought was simple: only include table items between dates for one of my fields (group by date).
The dates are in this format (example from table):
2005-08-24 22:11:00.000000
I used this SQL line to try and do this:
HAVING (((TABLE.A)=1) AND ((TABLE.B)=2) AND ((TABLE.C) Between #1/1/2013 12:0:0# And #5/1/2013 12:0:0#))
However it did not work: Table A and B groups worked fine, but I still get dates from 2005!
Any ideas?