N
Noel
Hi, sorry to double post but I sent this to the Query
section a few days ago (and repeated it) but so far have
received no reply. I hope for better luck here. Cheers
Hi, I am new to MailMerge and I want to print out letters
to Schools who each have one or more students allocated to
them. I have already got a query which selects the
relevant info from more than one table (which includes One
sided and Many sided relations). I have set up a Report
which uses Grouping to ensure that, when a School has more
than one student allocated, the School Name appears only
once with the student names listed against it (I have
grouped by SchoolID). However, when I set up a Mail Merge
based on the same query as used for the report, I get a
separate page for each student. Eg instead of one page
showing School A with Students1, 2 and 3, I get one page
showing SchoolA with Student1, a second page showing
SchoolA with Student 2 etc. Is there a way to group
records in a Mail Merge, just like you can do in the
Report, or is there a way to do this in the query itself?
The same question applies to printing labels based on this
query. I will want to print the School address only once,
irrespective of how many students they have been
allocated. Thanks, Noel
section a few days ago (and repeated it) but so far have
received no reply. I hope for better luck here. Cheers
Hi, I am new to MailMerge and I want to print out letters
to Schools who each have one or more students allocated to
them. I have already got a query which selects the
relevant info from more than one table (which includes One
sided and Many sided relations). I have set up a Report
which uses Grouping to ensure that, when a School has more
than one student allocated, the School Name appears only
once with the student names listed against it (I have
grouped by SchoolID). However, when I set up a Mail Merge
based on the same query as used for the report, I get a
separate page for each student. Eg instead of one page
showing School A with Students1, 2 and 3, I get one page
showing SchoolA with Student1, a second page showing
SchoolA with Student 2 etc. Is there a way to group
records in a Mail Merge, just like you can do in the
Report, or is there a way to do this in the query itself?
The same question applies to printing labels based on this
query. I will want to print the School address only once,
irrespective of how many students they have been
allocated. Thanks, Noel