Ignoring duplicate names in Address Labels Wizard esults

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

Guest

I queried this forum and tried every solution suggested. I'm still getting
duplicate labels. I used the Wizard to create the list. Any other suggestions?

Tired "Totals" query
Tried SQL statement SELECT DISTINCT
 
How about providing us with the SQL view of your report's record source?

Then view the datasheet to look for duplicates. If you see any duplicates
copy and paste the duplicated records into a reply.
 
I'll do that Wednesday as I'll be making life miserable for a few million /
billion dollar companies Tuesday.
 
Here's the SQL code from the query the Wizard created.

SELECT Extensions.ID, Extensions.Date_Entered, Extensions.
[Taxpayer Name], Extensions.[Taxpayer Address],
Extensions.City, Extensions.State, Extensions.ZIP,
Extensions.Telephone, Extensions.Email, Extensions.
[Account Nbr], Extensions.[FEIN/SSN],
Extensions.Requestor, Extensions.Req_Telephone
FROM Extensions
WHERE (((Extensions.Date_Entered) Between [Type the
beginning date:] And [Type the ending date:]));
 
And the second question in my previous reply.....?

--
Duane Hookom
MS Access MVP
--

RealGomer said:
Here's the SQL code from the query the Wizard created.

SELECT Extensions.ID, Extensions.Date_Entered, Extensions.
[Taxpayer Name], Extensions.[Taxpayer Address],
Extensions.City, Extensions.State, Extensions.ZIP,
Extensions.Telephone, Extensions.Email, Extensions.
[Account Nbr], Extensions.[FEIN/SSN],
Extensions.Requestor, Extensions.Req_Telephone
FROM Extensions
WHERE (((Extensions.Date_Entered) Between [Type the
beginning date:] And [Type the ending date:]));
-----Original Message-----
How about providing us with the SQL view of your report's record source?

Then view the datasheet to look for duplicates. If you see any duplicates
copy and paste the duplicated records into a reply.

--
Duane Hookom
MS Access MVP
--




.
Click to expand...
Click to expand...
 
I have a copy of the database zipped down to about 300KB. It might be easier
to just send it than try to explain it. Your thoughts?

Duane Hookom said:
And the second question in my previous reply.....?

--
Duane Hookom
MS Access MVP
--

RealGomer said:
Here's the SQL code from the query the Wizard created.

SELECT Extensions.ID, Extensions.Date_Entered, Extensions.
[Taxpayer Name], Extensions.[Taxpayer Address],
Extensions.City, Extensions.State, Extensions.ZIP,
Extensions.Telephone, Extensions.Email, Extensions.
[Account Nbr], Extensions.[FEIN/SSN],
Extensions.Requestor, Extensions.Req_Telephone
FROM Extensions
WHERE (((Extensions.Date_Entered) Between [Type the
beginning date:] And [Type the ending date:]));
-----Original Message-----
How about providing us with the SQL view of your report's record source?

Then view the datasheet to look for duplicates. If you see any duplicates
copy and paste the duplicated records into a reply.

--
Duane Hookom
MS Access MVP
--

I queried this forum and tried every solution suggested. I'm still getting
duplicate labels. I used the Wizard to create the list. Any other
suggestions?

Tired "Totals" query
Tried SQL statement SELECT DISTINCT

--
I know enuff to be dangerous.


.
Click to expand...
Click to expand...
Click to expand...
 
I would rather you answered my (an possibly others') questions.

Getting rid of duplicates usually involves a totals query. If you have
duplicates in your totals query, you need to remove columns or set the
totals to min or max.

--
Duane Hookom
MS Access MVP


RealGomer said:
I have a copy of the database zipped down to about 300KB. It might be
easier
to just send it than try to explain it. Your thoughts?

Duane Hookom said:
And the second question in my previous reply.....?

--
Duane Hookom
MS Access MVP
--

RealGomer said:
Here's the SQL code from the query the Wizard created.

SELECT Extensions.ID, Extensions.Date_Entered, Extensions.
[Taxpayer Name], Extensions.[Taxpayer Address],
Extensions.City, Extensions.State, Extensions.ZIP,
Extensions.Telephone, Extensions.Email, Extensions.
[Account Nbr], Extensions.[FEIN/SSN],
Extensions.Requestor, Extensions.Req_Telephone
FROM Extensions
WHERE (((Extensions.Date_Entered) Between [Type the
beginning date:] And [Type the ending date:]));

-----Original Message-----
How about providing us with the SQL view of your report's
record source?

Then view the datasheet to look for duplicates. If you
see any duplicates
copy and paste the duplicated records into a reply.

--
Duane Hookom
MS Access MVP
--

in message
I queried this forum and tried every solution suggested.
I'm still getting
duplicate labels. I used the Wizard to create the list.
Any other
suggestions?

Tired "Totals" query
Tried SQL statement SELECT DISTINCT

--
I know enuff to be dangerous.


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top