Query problem...using wildcard

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

Guest

I am tring to run a query with 2 tables in Access 2002. I need to match
customer names on the two tables. I drag the field Customer Name from one to
Customer Name on the 2nd so that it will pull the information. But, if the
name doesn't match exactly, it won't find it. Ex..one table is XYZ
Technologies and the other is XYZ Technologies Inc. I need to be able to use
a wild card to pull anything that is a close match. I don't know specific
names because they are large customer name tables so I can't just enter part
of the name and then *. Is there a way to do this? So that if one table
says XYZ Technologies and the other says XYZ Technologies Inc, it will pull
that information? Please Help!!!
 
There really is no other way than part of the name & * in a query.
You really have a more basic problem than that. The customer name should
never be in more than one table in your application. You best remedy is to
modify the design of your system to correct that problem.
 
In the filed criteria write

Like "*" & [Please enter name] & "*"

That will search the text any where in the field

In the end of the field use
Like "*" & [Please enter name]

In the start of the field use
Like [Please enter name] & "*"
 
Please ignore my post, I thought you want to search the table using a wild card
It's not an answer to find match records in between tables

--
Good Luck
BS"D


Ofer Cohen said:
In the filed criteria write

Like "*" & [Please enter name] & "*"

That will search the text any where in the field

In the end of the field use
Like "*" & [Please enter name]

In the start of the field use
Like [Please enter name] & "*"

--
Good Luck
BS"D


Chrissy said:
I am tring to run a query with 2 tables in Access 2002. I need to match
customer names on the two tables. I drag the field Customer Name from one to
Customer Name on the 2nd so that it will pull the information. But, if the
name doesn't match exactly, it won't find it. Ex..one table is XYZ
Technologies and the other is XYZ Technologies Inc. I need to be able to use
a wild card to pull anything that is a close match. I don't know specific
names because they are large customer name tables so I can't just enter part
of the name and then *. Is there a way to do this? So that if one table
says XYZ Technologies and the other says XYZ Technologies Inc, it will pull
that information? Please Help!!!
Click to expand...
Click to expand...
 
It's me again, you can use the like in the query as a join.

Something like

SELECT TableName_2.*
FROM TableName_2 INNER JOIN TableName_1 ON TableName_2.FieldName Like "*" &
TableName_1.FieldName & "*"
 
Back
Top