I'm making a mail merge Directory and have got it pretty much doing what it's supposed to. This tutorial was invaluable: http://windowssecrets.com/forums/sho...merge-Tutorial



I have a list of sales figures in the directory, and I can successfully add up the totals per salesperson but only if the total appears below the table of repeated data.

For example, I would like the letter to read:

Congratulations Josh! This month your totals were $3,500. Here are the details of your transactions:

7/7/13 $1,000
7/8/13 $2,000
7/9/13 $500

Again, I can total those numbers if the total appears below, but I can't display a total above. In my letters the above total appears as $0.

Any ideas how I can do this? Thanks!