Mail Merge Formatting...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbie - 11 Oct 2003 00:19 GMT

I am working on the formatting for a merge from Access. I
am trying to get the percentages correct and it's not
working.

MS Word's help file only shows that it would look like
this...

{MERGEFIELD mine \# x#.##%} or {MERGEFIELD mine \# "#.##%"}

Each of these put the decimal two additional spaces back,
even if I take out the percent sign. If I take out the
decimal, it rounds up to the whole number. I have found
that if I add a decimal, like {MERGEFIELD mine
\# .x#.##%}, it looks like: .95.52%
This is almost right. It's suppose to be: 95.52%

Please help.

TIA... debbie =}

Reply to this Message

Peter Jamieson - 11 Oct 2003 18:40 GMT

> Each of these put the decimal two additional spaces back,
> even if I take out the percent sign.

By "spaces" do you mean "character positions"?

If a percentage such as 95% is /stored/ as 0.95 in Access then you are
probably getting .95% when you want 95%. If so, it doesn't really matter
where you put the decimal point - it will always be wrong. Nor does the "%"
sign in the format help - it doesn't say "convert this number to a
percentage". It just says "put a percentage sign here".

So my guess is that you will need to use an { = } field to multiply your
fraction by 100 to get a percentage, e.g. something like

{ ={ MERGEFIELD myfield }*100 \# "x#.##%" }

where all the {} are inserted using ctrl-F9.

If the problem is that you are getting /spaces/ that you do not want, I'm
not sure what to do about that but let us know, and please tell use which
version of Word/Access you are using.

--
Peter Jamieson
MS Word MVP

> I am working on the formatting for a merge from Access. I
> am trying to get the percentages correct and it's not
[quoted text clipped - 15 lines]
>
> TIA... debbie =}

Reply to this Message