Ignore duplicates for mailing labels

Ignore duplicates for mailing labels

Post by UmVhbEdvbW » Sun, 27 Mar 2005 02:41:07


Taxpayer NameI've tried several of the solutions posted both here and in the
Reports board, but nothing clicks.
I used the Mailing Label Wizard to create labels from a table in Access 2002
SP3.
The fields, in Wizard Query Order are:

Taxpayer Name
Requestor
Req_Address
Req_City
Req_State
Req_ZIP
Date_Entered

I want to generate only one mailing label per Requestor. I've tried dropping
the Taxpayer Name filed and using SELECT DISTINCT but it doesn't want to work.
The Query properties are set to Unique.
Suggestions?
--
I know enuff to be dangerous.
 
 
 

Ignore duplicates for mailing labels

Post by Van T. Din » Sun, 27 Mar 2005 15:59:23

Post the SQL String of your Query.

--
HTH
Van T. Dinh
MVP (Access)




the
2002
dropping
work.