Type Mismatch in Expression

[danabilski]

I am trying to create a query linking an existing query and existing
table, but it will not allow me to open the query?! I get the error
message "Type Mismatch in Expression".

All of the pre-existing tables and queries in this database are linked
between Excel, AS400 and Access.

Can someone please help?

The main goal of this query is to duplicate another existing query
that has a table linked that has mismatched column headings from the
new DL source.

Thank you.

 

[John W. Vinson]

I am trying to create a query linking an existing query and existing
table, but it will not allow me to open the query?! I get the error
message "Type Mismatch in Expression".

That suggests that there is a type mismatch in some expression... i.e.
you're trying to join a Number field to a Text field, or some other
such error.

Since we cannot see any of these queries, nor do we know the datatypes
in your tables, all I can say is "find and fix the type mismatch".

If you could post the SQL view of the existing query, and the
datatypes of the fields that you're trying to join, maybe someone
could help, if you don't find the problem yourself.

John W. Vinson [MVP]