Wildcard for non matching records between tables

[Guest]

I'm looking for records in one table that do not have matches in a second
table. In this case I have two fields in common call "Application Name". I
know how to use the nonmatching Wizard or how to write real basic SQL. The
problem is I want to use the LIKE operator because the spellings on some of
these values may not be exact. I can't find any help on using LIKE other than
with wild cards with specific strings.

What's the best way to find inexact matches between two tables?

 

[Guest]

hi,

Initially, I would suggest not using psaces in entity names. This includes
table names as well as column names. And also form field names.
And something like this should help:

Like "*" & [forms]![formname]![Application_Name] & "*"

Hope this helps,
geebee

 

[Guest]

SELECT [Table 1].*
FROM [Table 1] LEFT JOIN [Table 2] ON [Table 1].[Application Name] = [Table
2].[Part Description]
WHERE ((([Table 2].[Application Name]) Is Null));

 

[Marshall Barton]

I'm looking for records in one table that do not have matches in a second
table. In this case I have two fields in common call "Application Name". I
know how to use the nonmatching Wizard or how to write real basic SQL. The
problem is I want to use the LIKE operator because the spellings on some of
these values may not be exact. I can't find any help on using LIKE other than
with wild cards with specific strings.

What's the best way to find inexact matches between two tables?

Like is as good as it gets using built in Access
capabilities. If you want to use rally powerful pattern
matching features try using Regular Expressions in the MS
VBScript Regular Expressions 6.6 library. Before you get
too involved with it, be aware that VBScript is used to
propagate viruses so some IT administrators delete it from
their systems.

Check VBA Help for "Wildcards" to see all the pattern
features that can be used with Like.