Query problem...using wildcard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chrissy - 01 Jun 2007 14:22 GMT

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!!!

Reply to this Message

Klatuu - 01 Jun 2007 14:26 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 6 lines]
> says XYZ Technologies and the other says XYZ Technologies Inc, it will pull
> that information? Please Help!!!

Reply to this Message

Ofer Cohen - 01 Jun 2007 14:30 GMT

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] & "*"

Signature

Good Luck
BS"D

Reply to this Message

Ofer Cohen - 01 Jun 2007 14:32 GMT

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

Signature

Good Luck
BS"D

> In the filed criteria write
>
[quoted text clipped - 18 lines]
> > says XYZ Technologies and the other says XYZ Technologies Inc, it will pull
> > that information? Please Help!!!

Reply to this Message

Ofer Cohen - 01 Jun 2007 14:38 GMT

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 & "*"

Signature

Good Luck
BS"D

Reply to this Message