Address labels: prevent duplicate mailings

C

[Cherub]

Greetings,

Does anyone have an elegant solution to the problem of producing a single
address label for a family when there are multiple records in the database
for each family member.
 
A

Arvin Meyer

Greetings,

Does anyone have an elegant solution to the problem of producing a single
address label for a family when there are multiple records in the database
for each family member.
Click to expand...

Use the DISTINCT predicate when building your query for the labels. You
still will get duplicates if the data is not consistent (Joe Smith is not
Joseph Smith. is not Joe P. Smith). Anyway, the syntax is:

Select Distinct FirstName, LastName, Address, City, State, Zip From
tblPeople
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
S

Sandra Daigle

My solution is to create a separate table for family (really for residence)
then add a foreign key field to each individual record which indicates the
family (or residence) to which they belong. Residence is really the correct
term here since a family could have members living at different residences
(not to mention the fact that some people may have multiple addresses) but
for most applications, family suffices. Whichever you choose, this is the
table for the address information.

Once this is properly normalized, running a query which selects only one
record per family is a snap.
 
M

Microsoft

Arvin,

I used your example and it works fine with the fields that I used for dupes.
What is the rest of the syntax to include all the fields in the table while
checking dupes against only 4 fields? Here is my SQL:

Select Distinct FN, LN, ADD1, CTY From tblDonor01

I need to add 13 other fields that are not used for calculating dupes. I
assume I should run a make table query and create a new table without the
dupes?

Best regards,
Scott B
 
Top