merge field is three decimals.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAC - 18 Dec 2003 01:03 GMT

I'm using an Access query as my data source.

I have a discount field of 10% in my query and have formateed that column as
a currency field, but it's showin on my merge documents in three decimals.

How can I make it show only two and be rounded?

Thanks.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Dec 2003 01:34 GMT

Hi Sac,

See the following page on fellow MVP Graham Mayor's website

http://www.gmayor.com/formatting_word_fields.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I'm using an Access query as my data source.
>
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

SAC - 18 Dec 2003 01:45 GMT

Got it! Thanks!

> Hi Sac,
>
[quoted text clipped - 17 lines]
> >
> > Thanks.

Reply to this Message

Graham Mayor - 18 Dec 2003 07:23 GMT

You might like to look at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm also - in
particular the Excel data section, as the problem and answer are the same
for Excel and Access.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Got it! Thanks!
>
[quoted text clipped - 23 lines]
>>>
>>> Thanks.

Reply to this Message