Hi, New to the forum and fairly new with Access. running xp pro sp3 and access 2010.
I am trying to design a reporting database and one of my queries is to sort my (currently 187) records into monthly groups which will subsequently be re-queried for further info.
right now my query works but i have 2 records showing a 9/25/2012 date that are being included in the results and with this query,
"where [Open Time]">#10/1/2012 7:00:00 AM# (open time is the field name and is short date formatted)
those 2 September dated records should not be included in the record set but are.
Is there a flaw in my query causing it to pick up those dates?
any help for this would be appreciated.