Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergin from Access2003 to Word 2003
Hello,
I just recently upgraded from office 2K to 2K3. I am mergin from the DB to Word reports. Prior to the switch the merging went fine. I've changed my regional settings to show three numbers after the decimal place, in numbers and currency, thinking this would help solve the issue. Still not working. I've looked at merge formatting and it looks like this: \#0.000 Is there something else I could be overlooking? Numbers like 0.209 (in access) are rounding up to 0.210 (in Word after merge). While 0.221 is rounding down to 0.220. It's essentially truncating the third digit. Does anyone have any advice? Thanks in advance. -- Somecallmejosh |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergin from Access2003 to Word 2003
As a workaround, you may find that reverting to the connection method Word
2000 used by default will do the trick: check Word Tools|Options|General|"Confirm conversions at open", go through the process of connecting to your access data source, and choose the DDE option when it is offered. You may need to remove the \#0.000 switches. Peter Jamieson "Joshua K Briley" wrote in message ... Hello, I just recently upgraded from office 2K to 2K3. I am mergin from the DB to Word reports. Prior to the switch the merging went fine. I've changed my regional settings to show three numbers after the decimal place, in numbers and currency, thinking this would help solve the issue. Still not working. I've looked at merge formatting and it looks like this: \#0.000 Is there something else I could be overlooking? Numbers like 0.209 (in access) are rounding up to 0.210 (in Word after merge). While 0.221 is rounding down to 0.220. It's essentially truncating the third digit. Does anyone have any advice? Thanks in advance. -- Somecallmejosh |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergin from Access2003 to Word 2003
Seems to have worked. Thanks Peter.
-- Somecallmejosh "Peter Jamieson" wrote: As a workaround, you may find that reverting to the connection method Word 2000 used by default will do the trick: check Word Tools|Options|General|"Confirm conversions at open", go through the process of connecting to your access data source, and choose the DDE option when it is offered. You may need to remove the \#0.000 switches. Peter Jamieson "Joshua K Briley" wrote in message ... Hello, I just recently upgraded from office 2K to 2K3. I am mergin from the DB to Word reports. Prior to the switch the merging went fine. I've changed my regional settings to show three numbers after the decimal place, in numbers and currency, thinking this would help solve the issue. Still not working. I've looked at merge formatting and it looks like this: \#0.000 Is there something else I could be overlooking? Numbers like 0.209 (in access) are rounding up to 0.210 (in Word after merge). While 0.221 is rounding down to 0.220. It's essentially truncating the third digit. Does anyone have any advice? Thanks in advance. -- Somecallmejosh |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Reveal codes in a word document | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Word & WordPerfect | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout |