duplicates query

[Guest]

I have an Access table that the info was imported from another program. I
have a field named [Company] and fields named [FirstName] [LastName]. Some
of the records because of the other program have the contact name as the
company name. I am looking for a query (language) that will find the records
where the [Company] is equal to the combined fields of [FirstName],[LastName]
or [Company] begins with [FirstName]. Is this possible? I am an
intermediate user.

Thanks!

 

[Smartin]

I have an Access table that the info was imported from another program. I
have a field named [Company] and fields named [FirstName] [LastName]. Some
of the records because of the other program have the contact name as the
company name. I am looking for a query (language) that will find the records
where the [Company] is equal to the combined fields of [FirstName],[LastName]
or [Company] begins with [FirstName]. Is this possible? I am an
intermediate user.

Thanks!

SELECT * FROM YourTable
WHERE [Company] LIKE [FirstName] & '*';

will catch both conditions.

Hope this helps!

 

[Guest]

Awesome!! Thanks Much

Susie

I have an Access table that the info was imported from another program. I
have a field named [Company] and fields named [FirstName] [LastName]. Some
of the records because of the other program have the contact name as the
company name. I am looking for a query (language) that will find the records
where the [Company] is equal to the combined fields of [FirstName],[LastName]
or [Company] begins with [FirstName]. Is this possible? I am an
intermediate user.

Thanks!

SELECT * FROM YourTable
WHERE [Company] LIKE [FirstName] & '*';

will catch both conditions.

Hope this helps!