Trailing Zeroes Stripped from Currency Field in Word Mail Merge from Access

  • Thread starter Thread starter Lorna Olsen
  • Start date Start date
L

Lorna Olsen

A field in my table has the Currency format. Trailing
zeroes to the right of the decimal point display fine in
Access (2002 and 2003) and export great to an Excel
workbook; however, when I perform a mail merge with this
data to a Word document the trailing zeroes are stripped
out, like this:

15.50 in the Access table, is 15.5 in the Word merge doc.

Can anyone help? Thanks in advance!
Lorna
 
You could create a query that wraps a function around the field, and use the
query instead of the table directly.
 
Back
Top