creating a statement of activity using Excel records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Goalie Girl - 05 Apr 2008 18:45 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 05 Apr 2008 22:47 GMT

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

Signature

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

>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
[quoted text clipped - 8 lines]
> packages
> to use for this or is access better?

Reply to this Message