<div>
Either use CInt(strColumnName) or CStr(intColumnName).<br />

<pre><code id="code-367075">Select blah1.key, blah2.key
from blah1
INNER JOIN
blah2
ON blah1.key = CStr(blah2.key) 
--OR-- 
Select blah1.key, blah2.key
from blah1
INNER JOIN
blah2
ON CInt(blah1.key) = blah2.key
</code></pre>
</div>


Either use CInt(strColumnName) or CStr(intColumnName).


Select blah1.key, blah2.key
from blah1
INNER JOIN
blah2
ON blah1.key = CStr(blah2.key) 
--OR-- 
Select blah1.key, blah2.key
from blah1
INNER JOIN
blah2
ON CInt(blah1.key) = blah2.key


<div>
You may need to create a query of any table changing the format of the relevant field.<br />
Then join the query with the other table.
</div>


You may need to create a query of any table changing the format of the relevant field.
Then join the query with the other table.

<div>
<div class="content wysiwyg-content">
I have two tables in MS Access that are suppose to share a common key...however the number in one is actually stored as a string while the other is stored as an int.<br />
<br />
I think I want to use the convert() function...<br />
<br />
Select blah1.key, blah2.key<br />
from blah1<br />
INNER JOIN<br />
blah2<br />
ON blah1.key = blah2.key<br />
<br />
How do I use the convert() or something like it for the join?<br />

</div>
</div>


I have two tables in MS Access that are suppose to share a common key...however the number in one is actually stored as a string while the other is stored as an int.

I think I want to use the convert() function...

Select blah1.key, blah2.key
from blah1
INNER JOIN
blah2
ON blah1.key = blah2.key

How do I use the convert() or something like it for the join?


How to join on two disparate keys (one is string, other is int)?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.