Filtering out duplicate labels, again

  • Thread starter Thread starter Kathy
  • Start date Start date
K

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
 
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
 
Back
Top