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!

S Swedowski wrote:
> 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!

--
Smartin

Awesome!! Thanks Much

Susie

"Smartin" wrote:

> S Swedowski wrote:
> > 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!
>
> --
> Smartin
>