merge field is three decimals.

[SAC]

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.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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

 

[SAC]

Got it! Thanks!

"Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS"

 

[Graham Mayor]

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.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>