Merge data to Word

[JohnWard1947]

I am using merge in Word to import a calculation from an Access query. The query calculation displays to 2 decimal points by setting format and decimal places - no problem here. In the Word merge field, the calculation is displayed to about 15 decimal places. I only want two decimal places. Any ideas?

Thanks
John

 

[neileg]

Format only changes the display, not the underlying data. Use Round() in your query to get the precision you want.