Access 2003 qry merge to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LaurieB - 19 Jul 2007 16:54 GMT

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.

Signature

LaurieB

Reply to this Message

Peter Jamieson - 19 Jul 2007 18:25 GMT

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

> 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.

Reply to this Message

LaurieB - 19 Jul 2007 20:20 GMT

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.

Signature

LaurieB

> If you use Alt-f9 to look at the underlying field code, what do you see?
>
[quoted text clipped - 12 lines]
> > of
> > 07.3% not have the 0 show.

Reply to this Message

Peter Jamieson - 19 Jul 2007 21:48 GMT

What do you see when you just have

{ MERGEFIELD Contribution }

?

Peter Jamieson

> We tried using { MERGEFIELD mynumber \#0.0% } what happens is if the
> percentage is 13.3% it shows as 3.3%.
[quoted text clipped - 19 lines]
>> > of
>> > 07.3% not have the 0 show.

Reply to this Message

LaurieB - 20 Jul 2007 17:26 GMT

Peter,
We took the switch out and just used { MERGEFIELD Contribution }. Here are
some of the different results that I copied from the merged document to here:
0.153, 0.15, 0.25, 0.237083, 0.1122, 0.0.

I hope this helps and I really appreciate your prompt assistance with this.

Signature

LaurieB

> What do you see when you just have
>
[quoted text clipped - 27 lines]
> >> > of
> >> > 07.3% not have the 0 show.

Reply to this Message

Peter Jamieson - 20 Jul 2007 20:21 GMT

OK, try

{ ={ MERGEFIELD Contribution }*100 \#0.0% }

Both pairs of {} need to be the special field code braces that you can
insert using ctrl-F9 - everything else is ordinary text.

(That's assuming 0.153 should display as 15.3% )

Peter Jamieson

> Peter,
> We took the switch out and just used { MERGEFIELD Contribution }. Here
[quoted text clipped - 39 lines]
>> >> > of
>> >> > 07.3% not have the 0 show.

Reply to this Message

Rate this thread: