Query- Type Mismatch In Expression

  • Thread starter Thread starter jpark3205
  • Start date Start date
J

jpark3205

I apoligize if this is repetitive. I have read through the other posts
about this problem and none of them seem to be what mine is about. I am
trying to do a query with 3 different tables. They all have a PS column. In
2 of the 3 tables it is the Primary key. I am getting the error message that
is "Type Mismatch in Expression" when I try to run the query. What am I
doing wrong? Thanks...
 
A type mismatch is a data type which doesn't match between tables. If you
try to link a text field to an autonumber (long integer), for instance,
you'll get a type mismatch.
 
jpark3205 said:
I apoligize if this is repetitive. I have read through the other posts
about this problem and none of them seem to be what mine is about. I am
trying to do a query with 3 different tables. They all have a PS column.
In
2 of the 3 tables it is the Primary key. I am getting the error message
that
is "Type Mismatch in Expression" when I try to run the query. What am I
doing wrong? Thanks...
Click to expand...


You'll need to post the SQL of the query, and the data types of all the
fields that are used in either joins or WHERE clauses.
 
Back
Top