Wildcards to capture all or parts of a name in a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am very new to Access. I have learned how to join two fields from two
different worksheets. However, the join only gives me records where the
fields have an exact match. Here's an example: If "Company Name" shows up in
both fields, the match occurs, but if "Company Name, Inc." is displayed in
one field, and only "Company Name" in the other field, a match does not
occur.

How do I build a query that will get me records from both fields containing
"*Company Name*"?

Thanks
 
You can use a non-equi join to do this, but the results may not be what you
want. You cannot build this type of join in query grid.

SELECT *
FROM TableA INNER JOIN TableB
 
Back
Top