Mergin from Access2003 to Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joshua K Briley - 24 Jul 2006 22:56 GMT

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.

Signature

Somecallmejosh

Reply to this Message

Peter Jamieson - 25 Jul 2006 00:48 GMT

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

> Hello,
>
[quoted text clipped - 14 lines]
> Does
> anyone have any advice? Thanks in advance.

Reply to this Message

Joshua K Briley - 25 Jul 2006 20:15 GMT

Seems to have worked. Thanks Peter.

Signature

Somecallmejosh

> As a workaround, you may find that reverting to the connection method Word
> 2000 used by default will do the trick: check Word
[quoted text clipped - 22 lines]
> > Does
> > anyone have any advice? Thanks in advance.

Reply to this Message