|
|
|
|
#1
03-20-2019, 01:04 AM
|
|||
|
|||
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.... 
|
|
#2
03-20-2019, 02:28 AM
|
||||
|
||||
|
As I said plainly enough in post 6:
Quote:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
#3
03-20-2019, 04:17 AM
|
|||
|
|||
|
Quote:
What will fix the problem? The data in Access is clearly displayed as currency. Cheers
|
|
| Tags |
| changing value, mergefield, wrong value |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Currency Field not showing $ and is rounding
|
Juliesctt | Mail Merge | 3 | 07-05-2016 06:43 PM |
|
Problem with currency field code
|
DIYman | Mail Merge | 2 | 09-22-2015 12:16 AM |
| Problem Displaying Headers Using Field Codes | OldProfessor | Word | 2 | 07-28-2015 07:51 PM |
| result of merge field is incorrect | VHV | Mail Merge | 3 | 06-16-2014 03:46 PM |
|
Displaying pictures from a field with a file path
|
okiegirl | Mail Merge | 4 | 07-28-2012 02:14 AM |
Windows 10 
Office 2016
Hybrid Mode