Re: Managing a data list and removing duplicates

Ok, but you still need some kind of criteria by which you define which records
to use. For instance, if you did want to restrict the mailing to one letter per
address, AND the addresses were entered in a uniform way ("22 Pine St." is not
equal to "22 Pine Street"), you could run a "Find Duplicates" query. The point
is, *you* have to come up with a way to tell Access which records to pay
attention to. See what I mean?

Regards,
RD

On Sat, 1 Oct 2005 00:22:01 -0700, Paul Mendlesohn
<PaulMendlesohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I obtain each database list from a dental practice this is something I will
>be doing on a regular basis with new lists of varying types. I will manually
>put the lists into a standardized format.
>It is only imortant that I write to one person at each address so I can sort
>the addresses by post code and first line of address. The other problem is
>that I don't want to write to Mr and Mrs if there is a single parent family.
>It wouldn't matter terribly if more than one person at some addresses
>received a letter, it's just that overall I have 12,000 roecords with 6,000
>dupilcates. Removing most of the duplicates will save a fortune on the
>mailing.
>thanks
>Paul
>"RD" wrote:
>
>> It *is* possible *if* you have a way to tell that the entries are, in fact,
>> members of the same family. At my job I often run into multiple instances of
>> names where the people are *not* related (especially true of Hispanic names).
>> One can do some pretty cool things with code but it can't perform magic or read
>> minds.
>>
>> So, do you have a way to absolutley identify members of the same family?
>>
>> Regards,
>> RD
>>
>> On Thu, 29 Sep 2005 08:07:01 -0700, Paul Mendlesohn
>> <PaulMendlesohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >I have a list of 12,000 names and addressed. A number of them are duplicates
>> >in that when there is a family there may be two or more members of the same
>> >family. I want to delete any duplicate records and change the remaining
>> >record title to Mr and Mrs, or just Mr or Mrs if there is one carer and the
>> >rest are kids.
>> >Is this possible with Access programming? Does anyone have any code I could
>> >use.
>> >Thanks
>>
>>

.

Relevant Pages

  • Re: intersection
    ... > result of performing an intersection on lists containing duplicate ... > duplicates that may show up in the result. ... > number of members in the result is so undefined that even within the ... The semantics of INTERSECTION are very rigid when you give it lists ...
    (comp.lang.lisp)
  • Re: Managing a data list and removing duplicates
    ... That is only the first stage. ... >>be doing on a regular basis with new lists of varying types. ... Removing most of the duplicates will save a fortune on the ... >>> members of the same family. ...
    (microsoft.public.access.modulesdaovba)
  • Finding Duplicates
    ... I have different areas enter names they'd like to be included in a mailing. ... Sometimes, there are duplicates. ... I've been trying to create a query that ... finds them so I can have the creators of the lists decide among themselves ...
    (microsoft.public.access.queries)
  • Re: Membership database updates
    ... The main database is in HQ and they send me a list ... of members in my branch. ... If you can help me write a query to do this in less steps it would be ... how do I import the updated lists for Feb and Mar as there is no ...
    (microsoft.public.access.tablesdbdesign)
  • Re: removing dupliates from 2 lists with similar content
    ... In XL2007 there is a feature to Remove Duplicates under the Data tab. ... sheet that others can just drop their lists into? ... Each contains unique entries, as well as ...
    (microsoft.public.excel.newusers)