Avatar of itsquad
Flag for United States of America

asked on 

Can an Access join act like a wildcard search?

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
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon