title: How to join tables together on columns with different datatypes?
body: <p>A Microsoft Access implementation is throwing a type mismatch error while trying to execute a macro that opens up some queries.  Most of the tables are linked to a SQL Server and I need to join two of the tables together that have different datatypes.</p>
  
  <p><strong>Table A:</strong><br>
  REFERENCE TEXT</p>
  
  <p><strong>Table B:</strong><br>
  REFNO NUMBER</p>
  
  <p>I would ordinarily want to correct the issue on the SQL Server side, but there are multiple apps hitting the same database and it would take a considerable amount of time to test all of them.  Furthermore, we are in the process of completely rewriting this application and any work I do today is completely throw-away...  </p>
  
  <p>If there is a way to make this join possible in access, I would save all kinds of time...</p>