 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Commercial Printing / May 2005Publisher 2003 catalog merge Dollar field problem trailing zeros
I am doing a merge from an access 2003 mdb into publisher, and there is one numeric field - a dollar field - which loses decimal zeros on the catalog merge. The zeros show up in the access table - the field is a numeric field with a currency format, but Publisher is dropping zeros after the decimal point thusly: $ 25.00 comes in as 25 (no decimal point) $ 25.50 comes in as 25.5 (decimal point but no last zero) $ 25.55 comes in ok as 25.55 TIA for solution to this problem. Define the field as text. How many decimal points have you selected in the regional options in the control panel?  SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com >I am doing a merge from an access 2003 mdb into publisher, and there is one > numeric field - a dollar field - which loses decimal zeros on the catalog [quoted text clipped - 9 lines] > > TIA for solution to this problem. I can't define the field as text in Access because it is the price of the product, and I have many reports that need to do various sums and calculations of this field. My regional options are set for .00 for numbers and currency. > Define the field as text. > How many decimal points have you selected in the regional options in the control [quoted text clipped - 13 lines] > > > > TIA for solution to this problem. A text field will remain exactly as you typed it, it matters not if it is a number. Might read this article, it addresses Excel, but it is the same with Access. Answer Box: Numbers don't merge right in Publisher http://office.microsoft.com/en-us/assistance/HA011165801033.aspx SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com >I can't define the field as text in Access because it is the price of the > product, and I have many reports that need to do various sums and [quoted text clipped - 18 lines] >> > >> > TIA for solution to this problem. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.