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 / March 2005

Tip: Looking for answers? Try searching our database.

Round numbers to 2 decimal places when using Word Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ALJ - 21 Mar 2005 16:33 GMT
How can I limit a mergefield to 2 decimal places using Mail Merge.  I am
connected to an Access query that is set up to limit results to 2 decimal
places but it doesn't appear the same in the merged Word Doc. Is there a
switch to accomplish this task or does anyone know of a way I can set the
field up?  Thanks!
Andy  
Peter Jamieson - 21 Mar 2005 19:23 GMT
You can try using a numeric formatting switch in Word, e.g. use Alt-F9 to
reveal the appropriate field code and change e.g.

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#"0.00" }

- have a look at Word help for other types of formatting you can apply.

You need to check that this does the correct kind of "limit"ing, i.e. if you
want rounding, make sure it does rounding; if you want truncation, make sure
it does that. If it doesn't do the thing you need you may need to change the
way you are limiting the decimal places in your query (and there can be
additional problems if the number comes from a field of type currency).

Peter Jamieson

> How can I limit a mergefield to 2 decimal places using Mail Merge.  I am
> connected to an Access query that is set up to limit results to 2 decimal
> places but it doesn't appear the same in the merged Word Doc. Is there a
> switch to accomplish this task or does anyone know of a way I can set the
> field up?  Thanks!
> Andy
ALJ - 21 Mar 2005 19:33 GMT
Thanks Peter, that did it!

> How can I limit a mergefield to 2 decimal places using Mail Merge.  I am
> connected to an Access query that is set up to limit results to 2 decimal
> places but it doesn't appear the same in the merged Word Doc. Is there a
> switch to accomplish this task or does anyone know of a way I can set the
> field up?  Thanks!
> Andy  
 
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.