Incorrect Numeric Field Formatting (Mailmerge)

[Frank Tolstyka]

I too have the problem described be the following link:
http://groups.google.com/groups?q=Q220547&hl=en&lr=&ie=UTF-8&selm=VA.0000239
2.007ee93a%40bob&rnum=2

Just wondering if anything has happened at MS about KB Q220547

Thanks,

Frank

 

[Cindy M -WordMVP-]

Hi Frank,

Which version of Word are you using (with Service Packs) and what's your data
source?

I too have the problem described be the following link:
http://groups.google.com/groups?q=Q220547&hl=en&lr=&ie=UTF-8&selm=VA.0000239
2.007ee93a%40bob&rnum=2

Just wondering if anything has happened at MS about KB Q220547

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Frank Tolstyka]

Hi Cindy:

I am using Word 2002 SP2 and an ODBC data source linked with MS query. I
also have an account that is using Word 2000 with the same problem.

Frank

 

[Cindy M -WordMVP-]

Hi Frank,

I am using Word 2002 SP2 and an ODBC data source linked with MS query. I
also have an account that is using Word 2000 with the same problem.

I've never, ever seen the problem under Word 2002. OTOH, the problem might
be with how this particular ODBC driver is communicating with Word. (MS
Query only puts together the data; Word still needs the ODBC connection to
the actual data source). Since you don't mention the application providing
the data, I'm assuming it's not a common one on the market?

Do you have any idea if it supports something like the FORMAT function, so
that you could preformat the dates as literal strings in MS Query?

How about linking the data via MS Query into Excel? Does that work? If so,
then you can at least merge this way.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Frank Tolstyka]

Cindy:

The ODBC connection is a common one - IBM AS/400 Client Access ODBC Driver
(32 bit). Does not support a FORMAT function. Using Excel seemed to slow
(this is an 'interactive' merge) but it does format correctly. I am now
currently formatting my dollar numerics in my database and bringing them
over as character. This works great for me. I was just wondering if MS ever
'fixed' this.
Thanks for all.

Frank