MS Word link MS Access table data - avoiding duplicates

[mous]

Hi All,

I have an MS Access table that currently links into word as a mail merge. Great!

Sample data as follows:

Tutor Student
Mr A Donald Duck
Mr A Mickey Mouse
Mr A Minnie Mouse
Mrs B Joe Bloggs

I want to produce a mail document that allows me to address each tutor separately, along with the respective student names in a grid.

Now I've setup the document, but when I view each document it produces the list of all students for each tutor.

e.g.

Dear Mr A

Your students are:

Donald Duck
Mickey Mouse
Minnie Mouse

-------------------

Dear Mrs B

Your Students are:

Joe Bloggs

Is this at all possible?

Thanks

 

[SRAB]

Mail merge will produce 1 letter for each record. You'd get 3 letters for Mr. A.

Try using a report instead, with a grouped query.
Query Example:
SELECT [MYTABLE].TUTOR, [MYTABLE].STUDENT
FROM [MYTABLE]
GROUP BY [MYTABLE].TUTOR, [MYTABLE].STUDENT;

Then you can format the report to look more like a letter and export it.