hi.
post your code. I'm not sure i can help but unless i see the code, all i
know for sure is that you have a syntax problem.

Regards
FSt1

"James T" wrote:

I have created an excel query using ODBC, and linking to a financial software
products tables.

I am attempting to enter in a criteria to reduce the number of records
returned.

I am trying to put in a criteria against a DATE field. However when in
enter in a date and run the query I get the following error "Syntax Error".

Can someone help??