C
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.
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.