Duplicate Letters

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have designed a Mail Report based on a Parameter query that lists and
produces a letter to the parents of all children that attend a specific
school. The Merge works fine except that where two children or more of the
one family attend the same school, the Merge produces more than one letter to
the same family.

Is there any way I can avoid this, that is, so that only one letter is
produced per family, regardless of the number of children attending the same
school?

Thanks for any help
 
Roger Bell said:
I have designed a Mail Report based on a Parameter query that lists and
produces a letter to the parents of all children that attend a specific
school. The Merge works fine except that where two children or more of
the
one family attend the same school, the Merge produces more than one letter
to
the same family.

Is there any way I can avoid this, that is, so that only one letter is
produced per family, regardless of the number of children attending the
same
school?

Thanks for any help
Click to expand...

The first question you have to ask yourself is how you decide what denotes a
family. I'd say that surname and first line of address should do it. I'm
assuming that you store this data. That being the case then you could do a
select *distinct* query to return a list of unique names and addresses and
then use that to limit what's output from your report's query.

HTH.

Regards,
Keith.
www.keithwilby.co.uk
 
Use an aggregate (Totals) query as the record source. In the child field,
use First instead of Group By.
 
Arvin Meyer said:
Use an aggregate (Totals) query as the record source. In the child field,
use First instead of Group By.
Click to expand...

Now that's why you're an MVP and I'm not. Nice one Arvin :)
 
Back
Top