Results 1 to 2 of 2
  1. #1
    slee68 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Nov 2013
    Location
    Atlanta, GA
    Posts
    1

    Access adds trailing 9's onto end of decimals. How do I fix this?

    This is my first post here, so I apologize if it may be in the wrong place or something.

    Here is the issue I am having. Our database is a SQL back-end, that is mirrored thru an access front-end. Most of the users are more comfortable with access. We have an excel spreadsheet, that allows users to prepare data they want to batch import to certain tables. The issue involves 2 tables, both have columns that will have decimals coming in. When the data is in the excel upload tool, it may go out to as much as 4 decimal places, but that is the most precision we will send. Somewhere along the line on the way to the db, these decimals get changed.



    For example - I may enter ".46" in the upload tool, export to the db, and then when I go view the record in the db, the value is ".459999999999". However, if I then go into the access db and manually type in ".46" into the field, it saves it correctly as ".460000000000".

    I need the database to populate these fields in the exact same way that we send them. Does anyone know what the issue could be? Is it in the excel file? Access? SQL? By the way - The data type in the SQL back end for these columns is decimal(38,18).

    Please feel free to ask for more clarification, as I realize there is a lot in information that goes into something like this. Any help would be greatly appreciated as I have been trying to fix this for so long and can't figure it out.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Search on: floating point error

    For a start, review https://www.accessforums.net/import-...0-a-28763.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 11-29-2012, 02:37 PM
  2. Replies: 3
    Last Post: 10-04-2012, 11:38 AM
  3. Access adds records it shouldn't add?
    By supertanno in forum Access
    Replies: 1
    Last Post: 11-07-2011, 09:57 AM
  4. Checking for trailing letter
    By jgelpi16 in forum Queries
    Replies: 2
    Last Post: 03-23-2010, 09:27 AM
  5. Replies: 9
    Last Post: 07-16-2009, 09:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums