Query help : Urgent please

[bhargav.desai]

Hello ACCESS gurus!

Can someone help me out here please?

I have a table, company, that contains about 1.5M records, and has
Company_NAME field. I have been supplied list that contains name of
owner and company_name. The company_name in supplied list is not EXACT
match as company_name in my company table. What I need to do is write
a query that fethces records that are similar, Like, in the name
supplied.

For example, in the supplied list I have a company named "Boys and
GIRLS Inc", what I need to get is all the records from my company
table that matches "Boys and GIRLS" anywhere in my name filed .

Thanks.

Can you please reply to my email at Bh***********@mci.com.

Thanks

[dkintheuk]

I'm based in the Reading office of MCI - look me up in the global email
list and give me a call.

I might be able to help. We should perhaps start an internal access
group!

Speak soon,

Robert McGregor

[Larry Linson]

LIKE "*boys and girls*" is the Criteria you want to use. Chances are that
you'll have to construct the Criteria or entire SQL statement in VBA code.

Larry Linson
Microsoft Access MVP
<bh***********@mci.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hello ACCESS gurus!

Can someone help me out here please?

I have a table, company, that contains about 1.5M records, and has
Company_NAME field. I have been supplied list that contains name of
owner and company_name. The company_name in supplied list is not EXACT
match as company_name in my company table. What I need to do is write
a query that fethces records that are similar, Like, in the name
supplied.

For example, in the supplied list I have a company named "Boys and
GIRLS Inc", what I need to get is all the records from my company
table that matches "Boys and GIRLS" anywhere in my name filed .

Thanks.

Can you please reply to my email at Bh***********@mci.com.

Thanks