office mail merge format question in access w/ word

[bharnett]

I am working with a Word document that pulls from an Access datasource. I am merging large numbers into the word doc, and I want them to be in the format xxx,xxx,xxx (instead of xxxxxxxxx). I set up the format on the query and the underlying table to format the numbers this way, but when the data is merged in the word doc, it's just raw numbers ie 84800000 instead of 84,800,000. The help file is totally useless.

 

[Norie]

You can format the MERGEFIELD in Word.

Right click on the field causing the problem and select toggle field codes.

You should then see something like this.

{MERGEFIELD YourAccessField}

To get the formatting you want something like this might work.

{MERGEFIELD YourAccessField \# ###,###,###}

Another way would be to use the Format statement in the query to turn the number into text with the required format.

The help file is not useless you just need to have some idea of what you are looking for.