merge currency into word document using windows xp

[Guest]

I use Windows XP and am trying to merge an access document with currency into
a word document. The numbers do not come out as currency or with the 2
decimals.

 

[Allen Browne]

Two possible approaches.

You may be able to add switches to the merge fields in the Word document so
they display as currency.

The other alternative is to make a query in Access that uses the Format()
function. This outputs text (rather than a real number), but that's fine for
merging into Word. Type something like this into the Field row of your
query:
Format([Field1], "Currency")
replacing "Field1" with the name of your field.