Data type mismatch in criteria expression.

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
 
K

Ken Snell [MVP]

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

;-)
 
I

ian

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
 
Top