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.

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

http://office.microsoft.com/en-us/wo...CH011218841033

Regards
Geoff



"CRBI" <(E-Mail Removed)> wrote in message
news:98E4EFAC-9A1A-49D3-B642-(E-Mail Removed)...
>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.