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.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.