Filtering out duplicate labels, again

[Kathy]

I am relatively new to developing reports and need to
print labels for donors to our charity. Many people give
money more than once a year, so I would like to prevent
printing of duplicate labels. I read the reply from
Allen Browne to a similar question on Nov 17, but cannot
get the "SELECT DISTINCT" to work. My exact entry
was "SELECT DISTINCT strDonor FROM qryAddress" I tried
entering this in the RecordSource for the labels report
itself and also the record source for the strDonor field,
but neither seem to work. Should I be doing this in
VBA??? Help would be appreciated. Kathy

 

[Lisa]

Try this
If your query is only used to generate the list of unique
records for this report then do it in the query itself.
Set the Query properties Unique Values to Yes.
(Right-click in the grey area in the query design view and
choose properties)
Lisa