Multi Dimensional Data

[davidwj]

I am creating a letter to send to people who have donated to us. So I
have a table of people, and I have a table of gifts that links to the
person via an id.

So my data may look like this:

John Smith 1/1/06 59.00
John Smith 2/1/06 59.00
John Smith 3/1/06 59.00

So I would like to create one letter that states

-------------------
Dear John Smith,

Blah Blah, your gift breakdown is as follows:

1/1/06 $59.00
2/1/06 $59.00
3/1/06 $59.00
Totaling $177.00

 

[Peter Jamieson]

Word merge isn't really designed to do this. If possible, do it as an Access
report. Or try the following links:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Peter Jamieson