View Single Post
 
Old 03-20-2019, 01:04 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

I know.

In Access, the field's data type is Currency.

In word, the field code is: {MERGEFIELD "Cost"\# £#,##0.00} and I have played with variances of the £#,##0.00.

The only fields affected are the ones that should show £23.50 (they are showing as £28.00).

I have amended another dataset to a figure with a decimal value, eg £??.50 and it seems to add £4.50 to any value with .50, but not if it is .25 for example....
Reply With Quote