Type Mismatch in expression joining two SQL tables with Access

[TRemington]

Hello, I am trying to join in two sql tables using an access query and I am
getting this error. I need to be able to convert an int to a varchar when
joining the tables, but I can't seem to find a way to do it in access? Any
advice would be appreciated.

 

[Bob Barrows]

Hello, I am trying to join in two sql tables using an access query
and I am getting this error. I need to be able to convert an int to
a varchar when joining the tables, but I can't seem to find a way to
do it in access? Any advice would be appreciated.

It can be done, just not directly in the Design View. In order to do it
in Design, you need to create another saved query in which the
conversion is done, and use that saved query instead of the table in
your query.

If you don't mind working in SQL View, you can use CStr in the join and
it will work, but you will never be able to switch to Design View.

Be aware that this query's performance will suffer.