Access/Word Mail Merge Currency lost digits
Home > IT Answers > Database > Access/Word Mail Merge Currency lost digits
OBI Girl
85 pts.
0
Q:
Access/Word Mail Merge Currency lost digits
Database issues, Microsoft Access, Access 2007, Microsoft Word, Mail merge
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6
How do I get the decimals to show?
ASKED: Dec 3 2008  8:42 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
SbElectric
1600 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Check the data type. Open the table in design mode & then click on the particular field name. Make the Data Type "Currency" from the Drop-Down list.
Hope it works.
Last Answered: Dec 5 2008  2:20 PM GMT by SbElectric   1600 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

OBI Girl   85 pts.  |   Jan 23 2009  2:48PM GMT

Data type is already set to currency. I’m wondering if there’s something I need to do in the Word doc. to tell it how I want the amount formatted. But I can’t seem to find a way to do that.

 

SbElectric   1600 pts.  |   Jan 26 2009  5:58PM GMT

It should work - I am puzzled too. The other item that I can think is in addition to Currency, set the decimal place to 2.

Open the report in design mode; click on the field that you are having problem with & right click & then select Properties. Now select Currency from the Drop down Format field.

I am assuming you are printing the Report via Access Report not from Word.
Good luck!

 

Msi77   800 pts.  |   Jan 26 2009  8:05PM GMT

Try the formula field in Word.
It may look like
{ =12345.23 # “$# ##0.00;($# ##0.00)” }

 

OBI Girl   85 pts.  |   Jan 27 2009  3:09PM GMT

BINGO!! Thank you so much Msi77! I am printing the letters from Word. I had to add a Numeric Format Switch to the field code.

 
0