Merging to a Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandra - 29 Aug 2003 17:59 GMT

Another question for you.

When I am merging from Access 2000 to Word 2002, the 200
records contains numerical figures. In access the format
for the numbers is how I want it to be i.e. 100,000, but
when I do the merge into word it appears at 100000.
Missing commas. Also if there is no figure in the access
field it shows up in word as a 0. I want the field to
remain empty rather than have a 0.

Reply to this Message

Doug Robbins - Word MVP - 30 Aug 2003 05:38 GMT

Hi Sandra,

You can either do this in Access by using a query as the data source and use
an

IIF(Number > 0, Format(Number, "#,##0"), "")

expression in the query.

Or use an If..Then..Else field in the mailmerge maindocument and use a \#
"#,##0" formatting switch inside the closing } of the merge field.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Another question for you.
>
[quoted text clipped - 5 lines]
> field it shows up in word as a 0. I want the field to
> remain empty rather than have a 0.

Reply to this Message