automatically finding fields that repeat?

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a database of prospective customers with the usual name, address,
etc. This database has to do with landowners in different towns. Often a
landowner owns land in multiple towns. If I'm going to send mailings to
them, I don't want to send more than one letter to the same person.

Of course I can simply force the data to line up alphabetically and
"manually" search for those last names- and for those that are duplicates, I
have a special field which is just a check off- by default, they're all
checked which indicates that they should receive mail. If not checked, my
query will not contain those records.

But, now that my database has several thousand records- whenever I add a new
town, it's time consuming to do this "manually".

Back in the old days of D-BASE- I wrote a program to do this. I can't even
remember how I did it- and I don't know if something like this is possible
with MS Access-2007. I'm sure it is, but before I did into the books, I'm
just hoping someone can point in my the right direction to do this as simply
as possible.

Thanks,
Joe
 
Joe said:
I have a database of prospective customers with the usual name,
address, etc. This database has to do with landowners in different
towns. Often a landowner owns land in multiple towns. If I'm going to
send mailings to them, I don't want to send more than one letter to
the same person.
Of course I can simply force the data to line up alphabetically and
"manually" search for those last names- and for those that are
duplicates, I have a special field which is just a check off- by
default, they're all checked which indicates that they should receive
mail. If not checked, my query will not contain those records.

But, now that my database has several thousand records- whenever I
add a new town, it's time consuming to do this "manually".

Back in the old days of D-BASE- I wrote a program to do this. I can't
even remember how I did it- and I don't know if something like this
is possible with MS Access-2007. I'm sure it is, but before I did
into the books, I'm just hoping someone can point in my the right
direction to do this as simply as possible.

Thanks,
Joe
Click to expand...

And if two different owners have the same last name? Unless you have an
identity field or fields that is more positive than last name I wouldn't even
worry about it. Send letters to each unique address. If more than one of those
is the same person they are quite used to it.
 
Back
Top