Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-09-2019, 05:12 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Exclamation Currency Field - Displaying Incorrect Value when Formatted

I have a mail merge in word from access (all 2016).

Before I apply the formatting, the data is displayed correctly @ 23.5.

However, when I apply the formatting: \# ,#.00 ~ MERGEFIELD "MyField" \# ,#.00 it displayed the value 28.00.



Any ideas would be appreciated, as it's driving me mad! I have fiddled with variances on \# ,#.00...
Reply With Quote
  #2  
Old 03-18-2019, 06:00 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your description suggests the value in Access is stored as '23 5', not '23.5' and, that without the addition of the picture switch, what you're seeing in the output as '23.5' is actually '23 5' with the space shown as '.'. Clicking on the symbol on the Ribbon's Home tab to turn off the formatting display would likely confirm that.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-19-2019, 01:21 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your description suggests the value in Access is stored as '23 5', not '23.5' and, that without the addition of the picture switch, what you're seeing in the output as '23.5' is actually '23 5' with the space shown as '.'. Clicking on the symbol on the Ribbon's Home tab to turn off the formatting display would likely confirm that.
Thanks, Paul, but I don't think that is it.

In Access, my field is a currency field and when word opens it pulls only data of 23.5.

When I click the , all I see is at 28.00..
Reply With Quote
  #4  
Old 03-19-2019, 02:54 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by DarrenE View Post
when word opens it pulls only data of 23.5.

When I click the , all I see is at 28.00..
But what do you see when you click the when only the 23.5 is displayed?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-19-2019, 04:43 PM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

I see: 28.00.
Reply With Quote
  #6  
Old 03-19-2019, 04:48 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

23.5 will not change to 28.00. just by clicking the symbol on the Ribbon's home tab...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
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
  #8  
Old 03-20-2019, 01:24 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

So why won't you answer what is, after all, a fairly simple question???
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 03-20-2019, 01:55 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
So why won't you answer what is, after all, a fairly simple question???
You asked:
Quote:
Originally Posted by macropod View Post
But what do you see when you click the when only the 23.5 is displayed?
I answered:
I see: 28.00.

If I remove the formatting (ie \# #,##0.00) I see:

23 5.

Was there another question I missed?

Cheers
Reply With Quote
  #10  
Old 03-20-2019, 02:28 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

As I said plainly enough in post 6:
Quote:
Originally Posted by macropod View Post
23.5 will not change to 28.00. just by clicking the symbol on the Ribbon's home tab...
to which you replied:
Quote:
Originally Posted by DarrenE View Post
I know.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #11  
Old 03-20-2019, 04:17 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
As I said plainly enough in post 6:to which you replied:
Yes, I know that. You asked me what showed when I did...

What will fix the problem?

The data in Access is clearly displayed as currency.

Cheers
Reply With Quote
  #12  
Old 03-20-2019, 01:40 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

When you're prepared to stop wasting peoples' time, maybe someone else will help. I'm done with this thread.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
changing value, mergefield, wrong value

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 09:29 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft