How do I perserve currency format from Access 2003 qyerry into a .

G

Guest

I am trying to merge data from Access 2003 into a Word 2003 document and
preserve the currency formating (or for that fact any and all formating)
 
V

Van T. Dinh

IIRC correctly, there are 2 ways:

1. Use a Calculated Field in your Query which "converts" your numeric value
to formatted currency text using the Format(). For example, instead of
passing your CurrField raw to Word, you can create a Calculated Field /
Column like:

FormattedCurr: Format([CurrField], "Currency")

(You can also use the function FormatCurrency(), IIRC.)

When you use Word for merging, use the Calculated Field rather than the raw
Field.

Check Access VB Help on the 2 functions above.

2. You can use the raw Field but you will have to set the formats for the
MergeFields in Word. You will need to check Word Help on this.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency changes when merging to Word 2
How do I maintain the currency format in merged fields? 1
merge currency into word document using windows xp 1
Change currency format in table. 3
merging currency from a database into a mail merge document 1
trouble with number format from access db to word form 6
Display Access currency field correctly in Word mail merge? 1
Zeros drop when exporting into Access 5

Top