Query- Type Mismatch In Expression

[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...

 

[Arvin Meyer [MVP]]

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.

 

[Dirk Goldgar]

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...

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.