A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A Word merge with Access adds decimal to numbers



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2005, 06:16 PM
Harlan
external usenet poster
 
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  
Old September 23rd, 2005, 06:26 PM
Anne Troy
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.