Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

Calculation field from SQL table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
markus.orchowski@gmail.com - 01 Aug 2006 21:28 GMT
Hi,

I read through some of the threads regarding MERGEFIELD syntax and can
not for the life of me get this to work.

I am following microsoft article: 90488
http://support.microsoft.com/?kbid=90488

In it clearly gives the syntax as:

{= ({MERGEFIELD order} + 100)}

In my document I have one line showing the amound and I want to show 5%
of the amount on the next line.

Every single document has an amount but all the percentage lines have
!Syntax Error, {

My code looks like this

{ MERGEFIELD "amount" \# $#,### }
{ =({ MERGEFIELD "amount"}*.05) \# $#,### }

As mentioned before there are no problems on the first line.  The
second line I get !Syntax Error, {.

Thank you,

-Markus
Peter Jamieson - 02 Aug 2006 08:37 GMT
The chances are that you have typed the inner { MERGEFIELD } using the
regular {} characters on the keyboard.

However, both pairs of {} need to be the special "field code braces" you can
create using ctrl-F9

Peter Jamieson
> Hi,
>
[quoted text clipped - 25 lines]
>
> -Markus
markus.orchowski@gmail.com - 03 Aug 2006 20:20 GMT
That did it.  the outside brackets were the special ones, but not the
inner ones.

Thanks!

> The chances are that you have typed the inner { MERGEFIELD } using the
> regular {} characters on the keyboard.
[quoted text clipped - 32 lines]
> >
> > -Markus

Rate this thread:






 
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.