Grouping records in mailing labels

[Guest]

Hi! I have a database in which I have attendees and seminars. One attendee
can attend several seminars. I have already queried out the information I
need for creating the mailing labels. I know I can create a mailing label
in Report and I know I can group records in a Report. However, I can't seem
to create a mailing label in which the records are grouped. Hope someone
could help me.
Thanks very much

 

[Guest]

There are two issues here, I think. Firstly the elimination of duplicate
attendee labels where an attendee has attended more than one seminar. For
that base the report on a SELECT DISTINCT query.

The second is the ordering of the labels. Depending on which order you want
the labels to print then select the field(s) for this as one or more group
levels in the Sorting and Grouping dialogue in report design view. Don't
give the group(s) a header or footer of course.