Duplicate Letters

[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

 

[Keith Wilby]

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

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

 

[Arvin Meyer [MVP]]

Use an aggregate (Totals) query as the record source. In the child field,
use First instead of Group By.

 

[Keith Wilby]

Use an aggregate (Totals) query as the record source. In the child field,
use First instead of Group By.

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