Too Many Decimal Places When Merging (1 Viewer)

[123James]

Hi everyone,

I have a field in a table holding numbers with no more than 2 decimal places eg. 96.87

Field Size = 'Double'
Decimal Places = 'Auto'

The data appears fine in Access and when exported to Excel.

However, when I merge the data into a Word document the numbers have loads of decimal places, so 96.87 becomes 96.87777777777777777777

What can I do!!??

Thanks

 

[Ron_dK]

Guess you have to verify the properties of the merged ( word) field and see if they are apropriately set.