Query with date range criteria... PLEASE HELP!

[tlcable7]

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?

Travis Cable
travis@bridgewebdesign.com

 

[GoDawgs]

Is InputDate a string or a date? If it's a date try this:

SELECT Count(INPUTDATE) AS C_LastMonth
FROM QMortgage_ameriquest WHERE INPUTDATE >= #9/1/2003#

Hope that helps.

Kevin

 

[rossno]

Try
SELECT Count(INPUTDATE) AS C_LastMonth
FROM QMortgage_ameriquest
WHERE INPUTDATE >= CDATE('9/1/2003')

 

[tlcable7]

Thanks,

This one worked perfectly...

SELECT Count(INPUTDATE) AS C_LastMonth
FROM QMortgage_ameriquest WHERE INPUTDATE >= #9/1/2003#

Travis Cable