I am new to Access, and having some problems when querying date ranges from a database.
Here is my query:
SELECT Count(INPUTDATE) AS C_LastMonth
FROM QMortgage_ameriquest WHERE INPUTDATE >= '9/1/2003'
Here is the error I get:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
That Query works fine on an MS SQL Database, why does it not work in Access, and what will work?