Access 2003 qry merge to word
We tried using { MERGEFIELD mynumber \#0.0% } what happens is if the
percentage is 13.3% it shows as 3.3%.
we currently have { MERGEFIELD Contribution \# .00.0% }. For some reason
they have a . in front of the 00.
--
LaurieB
"Peter Jamieson" wrote:
If you use Alt-f9 to look at the underlying field code, what do you see?
If you have something like
{ MERGEFIELD mynumber }
try changing it to
{ MERGEFIELD mynumber \#0.0% }
Peter Jamieson
"LaurieB" wrote in message
...
Using switches to format mergefields. Is there a way to not show a zero
in a
percentage field? Office Manager would like to show 13.3% ; in the case
of
07.3% not have the 0 show.
--
LaurieB
|