Duplicate Address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database for members. I want to print address lables however if
there is more than one person at the address I only want to print the address
once not two or 3 times. Also I do not want the name in the lables I assume
I do this in the report (which I will work on later).
 
If you don't want the names, leave name fields out of your query. To list
each address only once, in query design, activate the totals button. Then
set the Totals: section for address field(s) to Group By.
 
Ok I activated the Total's it made all of the fields show the Group
By....when I ran it it still had duplicate addresses.
 
Make sure that you haven't included something like the primary key field in
the query.

Also to a computer "123 Main St." and "123 Main Street" are NOT the same
address. You may need to clean up dirty data as any difference in any field
in the query will cause another record to show.
 
It depends what you mean by duplicates. 123 2nd Ave. and 123 Second Avenue
may be duplicates to you, but they are distinct to a database engine. Are you
SURE what you are seeing are indeed identical duplicates strings?
 
Back
Top