Data type mismatch in criteria expression.

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

I have a query that gives the message

"Data type mismatch in criteria expression."

The query looks at a single 'table' which is linked to a
csv file.

This only happens if I use the particular criteria value
912 if I use other values like 911 or 910 it works OK.

All the quoted values above exist in the csv file.

Does anyone have any ideas why this might be happening?

Thanks in advance for any help.

ian
 
You'll need to give us more details. We cannot see your data nor your query
nor your programming nor your database....

;-)
 
Many apologies for being so dozy.

It turned out that I had some numbers formated with the
comma thousand separator and this was screwing it up.

ian
 
Back
Top