If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
A Word merge with Access adds decimal to numbers
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to stop source prompt in mail merge from access | mvb | Mailmerge | 0 | September 6th, 2005 05:11 PM |
How can I fix the Access data source of the mail merge for Word | LCC | Mailmerge | 0 | August 29th, 2005 03:52 PM |
Envelope Address | GR | New Users | 5 | April 24th, 2005 09:48 PM |
Access 2003 Auto Mail Merge TO Word 2003 | Mark D Ski | General Discussion | 0 | March 11th, 2005 04:49 AM |
WORD XP mail-merge FAILS using ACCESS query | SueMackay | Running & Setting Up Queries | 4 | November 29th, 2004 04:11 PM |