<div>
The first two characters of the 10 character field will always be upper case alpha. The 2 character field in the other table will also always be upper case alpha. &nbsp;
</div>


The first two characters of the 10 character field will always be upper case alpha. The 2 character field in the other table will also always be upper case alpha.  

<div>
Then the join clause I used in my previous post should work.<br />
<br />

</div>


Then the join clause I used in my previous post should work.



<div>
Thank you very much. Very useful technique.
</div>


Thank you very much. Very useful technique.

<div>
<div class="content wysiwyg-content">
Table1 has a field 2 bytes in length. &nbsp;Table2 has a field 10 bytes in length. &nbsp;I would like to join the two tables on the Table1 field and the first two bytes of the Table2 field. &nbsp;How to do it? Thank you.
</div>
</div>


Table1 has a field 2 bytes in length.  Table2 has a field 10 bytes in length.  I would like to join the two tables on the Table1 field and the first two bytes of the Table2 field.  How to do it? Thank you.

Create a join on part of a field

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.