If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
% Format Lost
I am merging from access. I have created a query and used
calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack |
#2
|
|||
|
|||
% Format Lost
Word is now expected to provide the formatting and from your calculation has
worked out the result to be 0.41354836739 which equates to a round figure of 41% To get it to display that, you would need to use a calculated field in Word eg {={Mergefield fieldname} * 100 \# "0%"} -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: I am merging from access. I have created a query and used calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack |
#3
|
|||
|
|||
% Format Lost
This may sound like I know nothing, but when I enter that
formula a santax error comes up, or a undefined bookmark, ANDORRAPE. messsge comes up. What is the exact code I would need to input for the merge field "andorrapercent" for example? Also it is in the formula menu under table? Thanks Jack -----Original Message----- Word is now expected to provide the formatting and from your calculation has worked out the result to be 0.41354836739 which equates to a round figure of 41% To get it to display that, you would need to use a calculated field in Word eg {={Mergefield fieldname} * 100 \# "0%"} -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: I am merging from access. I have created a query and used calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack . |
#4
|
|||
|
|||
% Format Lost
If the data field is called 'andorrapercent'
then the construction would be: {={Mergefield andorrapercent} * 100 \# "0%"} Note that you need to enter this manually using CTRL+F9 to set each pair of field boundaries - see http://www.gmayor.com/formatting_word_fields.htm which I updated as a result of your question. -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: This may sound like I know nothing, but when I enter that formula a santax error comes up, or a undefined bookmark, ANDORRAPE. messsge comes up. What is the exact code I would need to input for the merge field "andorrapercent" for example? Also it is in the formula menu under table? Thanks Jack -----Original Message----- Word is now expected to provide the formatting and from your calculation has worked out the result to be 0.41354836739 which equates to a round figure of 41% To get it to display that, you would need to use a calculated field in Word eg {={Mergefield fieldname} * 100 \# "0%"} -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: I am merging from access. I have created a query and used calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack . |
#5
|
|||
|
|||
% Format Lost
I am still trying to resolve this, but I get the error
message "!santex error, andorrape" I am using Word 2000 (I don't know if this makes a difference) Thanks Jack -----Original Message----- If the data field is called 'andorrapercent' then the construction would be: {={Mergefield andorrapercent} * 100 \# "0%"} Note that you need to enter this manually using CTRL+F9 to set each pair of field boundaries - see http://www.gmayor.com/formatting_word_fields.htm which I updated as a result of your question. -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: This may sound like I know nothing, but when I enter that formula a santax error comes up, or a undefined bookmark, ANDORRAPE. messsge comes up. What is the exact code I would need to input for the merge field "andorrapercent" for example? Also it is in the formula menu under table? Thanks Jack -----Original Message----- Word is now expected to provide the formatting and from your calculation has worked out the result to be 0.41354836739 which equates to a round figure of 41% To get it to display that, you would need to use a calculated field in Word eg {={Mergefield fieldname} * 100 \# "0%"} -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: I am merging from access. I have created a query and used calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack . . |
#6
|
|||
|
|||
% Format Lost
I have now figured it out, blame it on a long day at work. Thank you VERY much, Jack -----Original Message----- I am still trying to resolve this, but I get the error message "!santex error, andorrape" I am using Word 2000 (I don't know if this makes a difference) Thanks Jack -----Original Message----- If the data field is called 'andorrapercent' then the construction would be: {={Mergefield andorrapercent} * 100 \# "0%"} Note that you need to enter this manually using CTRL+F9 to set each pair of field boundaries - see http://www.gmayor.com/formatting_word_fields.htm which I updated as a result of your question. -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: This may sound like I know nothing, but when I enter that formula a santax error comes up, or a undefined bookmark, ANDORRAPE. messsge comes up. What is the exact code I would need to input for the merge field "andorrapercent" for example? Also it is in the formula menu under table? Thanks Jack -----Original Message----- Word is now expected to provide the formatting and from your calculation has worked out the result to be 0.41354836739 which equates to a round figure of 41% To get it to display that, you would need to use a calculated field in Word eg {={Mergefield fieldname} * 100 \# "0%"} -- Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word Jack wrote: I am merging from access. I have created a query and used calculations. I've formatted the calculated fields to display as a percentage with no decimal places. When opening the query the formatting works. When I merge to Word the formatting is lost and istead of saying 40%, it will come up as 0.41354836739. Any support would be very helpful. Jack . . . |
Thread Tools | |
Display Modes | |
|
|