Strange linked table/query problem

[jimday1982]

First, let me say that my linked tables are opening fine, but I have a query that uses one of my linked tables (it's linking to a foxpro database) and when I try to run the query, I get this error:

ODBC connection failed - [Microsoft][ODBC Visual Fox Pro Driver] Operator/Operand type mismatch (#301)

Like I said, my tables open up fine, but my queries won't...anyone know what's going on and how this is fixed?

 

[Crilen007]

Perhaps one of the fields you are linking in the tables isnt the same format (Number, text, etc..) as the one its linking to?