Access Query and Word Mail Merge

[CRBI]

I have an access database in which I've written a query to pull certain data.
I am now performing a mail merge in Microsoft Word for that data. Everything
works perfectly except this one thing -- in the table (and therefore the
query itself) I have a field for contribution amount. In the table design I
have the data type as Currency and the properties as 2 decimal places. When
I view this info in datasheet view, it shows correctly, as $140.50. However,
once I run the mail merge and use that field, it only shows $140.5. I have
wracked my brains and cannot figure out why it doesn't show the full number.
Does anybody have any ideas here? And please, not too complicated for a
entry level user.

 

[GeoffG]

Take a look at the section "Muck Around with Field Codes in Word"
in the following article:

http://office.microsoft.com/en-us/word/HA011164951033.aspx?pid=CH011218841033

Regards
Geoff