creating a statement of activity using Excel records

[Goalie Girl]

I need to create a statement of activity for families in our school. In
excel, I have multiple records for each family. Each record contains the
info for one purchase date and then all have multimple purchase dates. I am
good with doing mail merges when the data in one record is put on one page in
word. iIs there a way to tell word to pull all the records for one family
(multiple records in excel) and put them on one page in word. I would then
need to total some of the columns also. Are excel and word the best packages
to use for this or is access better?

 

[Doug Robbins - Word MVP]

What you are trying to perform is a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at:

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

Or take a look at the following Knowledge Base Article:

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

or at:

http://cornell.veplan.net/article.aspx?&a=3815

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP