Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
numeric pictu formating merge field without rounding decimal digits?
hello,
i'm not very used to ms word and have a problem concerning formating a merge field with a numeric picture... my datasource is a ms access db, especially a numeric (double) field which for example contains a value like: 9957,7992. in the mail merge this value should be displayed as a currency value like: 9.957,79 USD (i'm from europe/austria). so i did something like this: {MERGEFIELD MyDBField \# "#.00,00 USD;(#.00,00 USD)"} in order to format this field. so the big probelm i have ist the output: 9.975,80 USD was rounded but i need the original value: 9.975,79 USD. is anyone out there who can help me with this? THANX!!! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
numeric pictu formating merge field without rounding decimal digits?
Hi Rookie07,
This would be better done on the Access side, using an expression in a Query. Word doesn't provide a lot of good, strong functionality for dealing with field content, while with Access you have a number of VB(A) functions you can integrate into queries. I suggest you try something like this: Amt: (Int({AmountFieldName}*100)/100) i'm not very used to ms word and have a problem concerning formating a merge field with a numeric picture... my datasource is a ms access db, especially a numeric (double) field which for example contains a value like: 9957,7992. in the mail merge this value should be displayed as a currency value like: 9.957,79 USD (i'm from europe/austria). so i did something like this: {MERGEFIELD MyDBField \# "#.00,00 USD;(#.00,00 USD)"} in order to format this field. so the big probelm i have ist the output: 9.975,80 USD was rounded but i need the original value: 9.975,79 USD. is anyone out there who can help me with this? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
numeric pictu formating merge field without rounding decimal digits?
hello,
thank you for your reply!!! i think i finally made it with this code: {SET A"{MERGEFIELD "zahl"}"}{SET B "{=INT(A*100)/100}"}{B\# "#.00,00 USD;(#.00,00 USD)"} THANX!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using IF to find whether a Merge Field contains a substring | Mailmerge | |||
numeric field picture switch | Microsoft Word Help | |||
Home Phone field not getting picked up in Merge | Mailmerge | |||
Merge Fields and Formating - How to easily repeat a pre-set merge. | Mailmerge | |||
suppress invalid merge field word 2003 | Mailmerge |