Display Access currency field correctly in Word mail merge?

S

Sherry

We have a current Access database and we are trying to pull currency fields
into a Word form letter using Mail Merge. In mail merge the data is
displaying with 3 decimal points or more instead of 2. So a dollar amount
displays as $7.045 instead of $7.05. We have checked our field formats.
Does anybody have any ideas, suggestions? Is this a bug in the new Office
2003? Everything worked fine when we had Office 2000.
 
D

Douglas J. Steele

The best approach is to create a query that uses the Format function on the
fields in question, and use the query for the merge.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Grouping Names in Mail Merge 0
mail merge currency 2
Access Query and Word Mail Merge 1
Some mail merge fields not pulling into document 2
Access Database Query to Microsoft Word Mail Merge 1
Mail Merge Help 0

Top