PC Review


Reply
Thread Tools Rate Thread

duplicates query

 
 
=?Utf-8?B?UyBTd2Vkb3dza2k=?=
Guest
Posts: n/a
 
      2nd Apr 2007
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!
 
Reply With Quote
 
 
 
 
Smartin
Guest
Posts: n/a
 
      3rd Apr 2007
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
 
Reply With Quote
 
=?Utf-8?B?UyBTd2Vkb3dza2k=?=
Guest
Posts: n/a
 
      3rd Apr 2007
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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicates in Query Louise Microsoft Access Queries 1 6th Oct 2008 06:50 PM
Duplicates Query shamrox Microsoft Access Queries 0 30th Jan 2008 03:31 PM
Find duplicates in query with query =?Utf-8?B?Q2hhZA==?= Microsoft Access 6 28th Mar 2007 02:05 PM
Run duplicates query and delete duplicates? =?Utf-8?B?QnJvb2s=?= Microsoft Access Queries 1 5th Oct 2005 01:18 PM
Re: A query with duplicates only John W. Vinson Microsoft Access 4 2nd Sep 2003 01:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:58 PM.