Ms Access, Linked SQL, Date Filter
Posted on 2004-09-28
I have an Access database with linked SQL tables. I have created a Select query based on one table which has a field called Transaction Date with a datatype of smalldatetime. When I enter criteria for the field (i.e., >=#1/1/2004# AND <=#6/1/2004#), the query returns records outside the date range requested. I have seen this before, but cannot remember the cure.
Assistance Sincerely Appreciated!!!