Duplicate Records

[Guest]

I am trying to create a mailing list of everyone in the database, but I do
not want duplicate records to show. I am going to use the phone number as the
search field, but i don't know what critera to put in the query to check for
this. Do I have to delete the duplicate records before running the query for
the mailing list.

Also, I have another mailing list that I am working on that I created using
the label wizard. I am using template 5160 because the labels are 1" X 2 5/8"
3 columns. It only allows me to use 4 lines. I need 5. Here is the layout I
am looking for.
<EndDate>
<Title> <First> <MI> <Last>
<Street Address>
<2ndStreetAddress>
<City>, <State> <Zip>
When I try to add the fifth line in the design view, I get an "Unbound
Control" message. When I run the query, I am prompted for a parameter for
the last line. Any suggestions.

 

[David Lloyd]

Scott:

You may want to investigate the DISTINCT and DISTINCTROW keywords in SQL to
see if they would help you remove the duplicates.

Regarding the labels, you need to check the RecordSource behind the labels
to make sure the City, State and Zip values are included. You will also
need to set the Control Source property for the those same field in the
label report.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to create a mailing list of everyone in the database, but I do
not want duplicate records to show. I am going to use the phone number as
the
search field, but i don't know what critera to put in the query to check for
this. Do I have to delete the duplicate records before running the query for
the mailing list.

Also, I have another mailing list that I am working on that I created using
the label wizard. I am using template 5160 because the labels are 1" X 2
5/8"
3 columns. It only allows me to use 4 lines. I need 5. Here is the layout I
am looking for.
<EndDate>
<Title> <First> <MI> <Last>
<Street Address>
<2ndStreetAddress>
<City>, <State> <Zip>
When I try to add the fifth line in the design view, I get an "Unbound
Control" message. When I run the query, I am prompted for a parameter for
the last line. Any suggestions.