<div>
and if you want all values from Table1 and only the &quot;fuzzy matches&quot; from table 2 use a LEFT JOIN in the above syntax
</div>


<div>
Niiiiice! &nbsp;Never considered that as an option in the SQL window! &nbsp;I always just looked at the line in the query builder and double clicked it there to select join type... Wish Access had that pre-programmed in there! &nbsp;Thanks guys!
</div>


<div>
<div class="content wysiwyg-content">
In the Query Builder window I have two tables, one has an indexed ItemNo field and in the other table, their is also a ItemNo value in the &quot;Handle Field&quot;, however it's in a string that has other values that will of course not exactly match the ItemNo value. &nbsp;So when I try to join them... no results.<br />
<br />
It'd be cool if my join could look through the string for a match and produce the matched results.<br />
<br />
I'm sure it's not possible via a join, however what would be a good method to do this?<br />
<br />
Thanks, Kevin
</div>
</div>


In the Query Builder window I have two tables, one has an indexed ItemNo field and in the other table, their is also a ItemNo value in the "Handle Field", however it's in a string that has other values that will of course not exactly match the ItemNo value.  So when I try to join them... no results.

It'd be cool if my join could look through the string for a match and produce the matched results.

I'm sure it's not possible via a join, however what would be a good method to do this?

Thanks, Kevin

Can an Access join act like a wildcard search?

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.