Decimal Numbers Not Importing Properly in Word

  • Thread starter Thread starter Pam at Fly-by-Night Books
  • Start date Start date
P

Pam at Fly-by-Night Books

I had no problems populating my Word price-label file
with data from an Access table until I upgraded to Office
XP. Now, I'm having problems with how the prices import.
The decimal point is often missing, as are trailing
zeros. When I have a price that is not a full dollar
amount, I get a price in Word that doesn't even seem
related, for example, $12.50 imports as $17. I tried
using switches in Word, but nothing seemed to solve the
problem. When I export the Access query to a text file to
check it, the prices seem fine. Please advise on how to
fix this problem. I'm having so many problems using
Access tables and queries in Word now that I've upgraded
that I'm thinking of going back to Office 2000. TIA.
 
Hi Pam,

This sounds more like a Word problem than an Access one and you may get
better answers from www.mvps.org/word or the Word newsgroups.

How are you "populating" the file? Mailmerge? Automation? If the former,
can you merge successfully from the text file instead of directly from
the query?
 
John -

Sorry I'm so late in responding. I had a bad fall, then
got sick. Anyway, I can import the data successfully
directly from the Access table or from a text file
resulting from a query, but not directly from the query.
The table has almost 4,000 records, so using MailMerge to
pull the data from it is extremely time consuming.
Similarly, exporting the query data to a text file is one
more step that I would like to avoid. However, I guess
I'll have to choose one of those methods. I have no clue
why the data won't import in the correct format directly
from the query, but this seems like a design flaw in
Access.

Pam
Fly-by-Night Books
Flint Hill, Virginia
-----Original Message-----
Hi Pam,

This sounds more like a Word problem than an Access one and you may get
better answers from www.mvps.org/word or the Word newsgroups.

How are you "populating" the file? Mailmerge? Automation? If the former,
can you merge successfully from the text file instead of directly from
the query?

I had no problems populating my Word price-label file
with data from an Access table until I upgraded to Office
XP. Now, I'm having problems with how the prices import.
The decimal point is often missing, as are trailing
zeros. When I have a price that is not a full dollar
amount, I get a price in Word that doesn't even seem
related, for example, $12.50 imports as $17. I tried
using switches in Word, but nothing seemed to solve the
problem. When I export the Access query to a text file to
check it, the prices seem fine. Please advise on how to
fix this problem. I'm having so many problems using
Access tables and queries in Word now that I've upgraded
that I'm thinking of going back to Office 2000. TIA.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top