Reply
 
Thread Tools Display Modes
  #1   Report Post  
Harlan
 
Posts: n/a
Default A Word merge with Access adds decimal to numbers

When using a Word 2003 merge form and merging data from Access 2003, why does
the merge add decimal places to a number?

For example: 2300.9 is in the Access table but in the Word form it is
changed to 2300.89999.

The data in the Access table is formatted for only 1 decimal place.
--
HRJ in Montana
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Something in the database is FORMATTING it to one decimal, Harlan. You can
change your query/table, or you can just change the mergefield format. See
this:
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Harlan" wrote in message
...
When using a Word 2003 merge form and merging data from Access 2003, why
does
the merge add decimal places to a number?

For example: 2300.9 is in the Access table but in the Word form it is
changed to 2300.89999.

The data in the Access table is formatted for only 1 decimal place.
--
HRJ in Montana



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM
How do I get rid of page numbers. The page number virus flamestar Microsoft Word Help 3 August 19th 05 02:31 AM
apply a template to existing documents Bubba Gump Shrimp Page Layout 2 July 28th 05 04:46 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM


All times are GMT +1. The time now is 07:13 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"