[RobinB]

I am trying to format an access database percentage (set up as a Double -
Percent - 2) in access as, for example, 2.50% in word. My mergefield looks
like this:
{MERGEFIELD Merit\#0.00%}
Unfortunately it keeps returning 0.02% rather than the 2.60%. Can you tell
me where I am going wrong?

[Suzanne S. Barnhill]

You need to multiply by 100. Keep in mind that 2.60% is 0.026.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"RobinB" u54245@uwe wrote in message news:9b16454a3b30c@uwe...
I am trying to format an access database percentage (set up as a Double -
Percent - 2) in access as, for example, 2.50% in word. My mergefield
looks
like this:
{MERGEFIELD Merit\#0.00%}
Unfortunately it keeps returning 0.02% rather than the 2.60%. Can you
tell
me where I am going wrong?

[Doug Robbins - Word MVP]

Use { = { MERGEFIELD Merit } * 100 \# 0.00% }

You must use Ctrl+F9 for each pair of field delimiters { }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"RobinB" u54245@uwe wrote in message news:9b16454a3b30c@uwe...
I am trying to format an access database percentage (set up as a Double -
Percent - 2) in access as, for example, 2.50% in word. My mergefield
looks
like this:
{MERGEFIELD Merit\#0.00%}
Unfortunately it keeps returning 0.02% rather than the 2.60%. Can you
tell
me where I am going wrong?