 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2007Add 2 Currency Fields Together - Word 2000
Hello, I have 2 currency fields that need to be added together to create a 'total premium' field. Is this possible? Thanks, Chris Something along the lines - {=({Mergefield Firstfield} + {Mergefield Otherfield}) \# "$,0.00"} See also http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello, > [quoted text clipped - 3 lines] > Thanks, > Chris Thanks Graham. I tried that and when I hit Alt+F9 to toggle, it displayed !SYNTAX ERROR,1 I've tried playing with spaces between the plus sign vs. no spaces and various other variations but to no effect. Thanks, Chris > Something along the lines - > [quoted text clipped - 8 lines] > > Thanks, > > Chris It will give a syntax error unless both fields are present and contain numeric data. Update the field (F9) Create a directory merge containing just these fields. Merge to a new document and see what happens? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks Graham. I tried that and when I hit Alt+F9 to toggle, it > displayed [quoted text clipped - 27 lines] >>> Thanks, >>> Chris Funnily enough, as I was writing my last message, I thought it might because the fields weren't yet populated. This has since proved to be the case and it does work. Thanks for your help again. I may be on again later for something else. Kind regards, Chris > It will give a syntax error unless both fields are present and contain > numeric data. Update the field (F9) [quoted text clipped - 32 lines] > >>> Thanks, > >>> Chris
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.