Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
KKPeters KKPeters is offline
external usenet poster
 
Posts: 1
Default Not getting correct Totals for sorted list by Vendor

Using the logic from MS Article ID: 294686 I create a sorted list by Vendor.
Now I am trying to total charges to be at the end of the letter.

The total of the first page is wrong the first record is added in 3 time but
after that
everything is correct except for the last page there is not a total at all.

Any suggestions is appreciated
Here is my code:

{if {mergerec} = "1" {mergefield VENDOR_NAME}{set amt =0 }{set fee =25}

{set place1 {mergefield VENDOR_NAME}}

{if {place2} {place1} "Total: {Tot + fee\# $#,###.#0}
-----------------Page Break----------------------------------
{mergefield VENDOR_NAME}

{MERGEFIELD VENDOR} {MERGEFIELD PO} {MERGEFIELD PICKUP_CHARGE \#
$#,###.#0}{set Tot {=amt + {MERGEFIELD PICKUP_CHARGE }" "{MERGEFIELD VENDOR}
{MERGEFIELD PO} {MERGEFIELD PICKUP_CHARGE \# $#,###.#0}{set Tot {=Tot
+{MERGEFIELD PICKUP_CHARGE }}{set place2 {mergefield VENDOR_NAME}} {set amt
=0 }



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use mail merge to create a list sorted by category in Word Malhyp Mailmerge 3 February 10th 07 11:18 AM
"How to use mail merge to create a list sorted by category in Word" malhyp Mailmerge 2 February 5th 07 02:15 PM
Mailmerge to create list sorted by category not working Simon Mailmerge 1 January 10th 07 03:38 PM
Mail Merge to Create a List Sorted by Category dhoward via OfficeKB.com Mailmerge 2 April 6th 06 08:47 PM
How do I put vendor list into label in Word? GeoPol New Users 1 January 17th 05 07:43 PM


All times are GMT +1. The time now is 07:25 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"