Results 1 to 3 of 3
  1. #1
    Poohbear0471 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    78

    Calculated field decimal places

    I'm sure I'm just having a brain dead moment, but... I have a calculated field based on values in three different fields.



    Original Weight - Double, General Number, Auto decimal places
    Original Yardage - Double, General Number, Auto decimal places
    Current Weight - Double, General Number, Auto decimal places
    Current Yardage - Calculated =Original Yardage/(original weight)/(current weight), Double, General Number, 2 decimal places

    I'm getting the correct results, except my result is displaying up to 13 decimal places instead of 2.

    For example, Original Weight = 30 oz & Original Yardage = 352 yds. Current Weight is 1 oz. My result is displaying 11.7333333333333, instead of 11.74.

    I tried changing the Decimal Places for each field to 2 and I still get the same result. What do I have formatted wrong?

  2. #2
    Poohbear0471 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    78
    Disregard... Found my solution.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Be aware that you shouldn't use Calculated FIELDS in tables. The calculations are not reliable.
    See Calculated Fields and Calculated fields misinterpreted

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

Similar Threads

  1. Replies: 7
    Last Post: 11-27-2017, 08:47 PM
  2. Replies: 5
    Last Post: 02-26-2015, 11:22 AM
  3. Formatting for 3 decimal places
    By Triland in forum Forms
    Replies: 12
    Last Post: 01-24-2013, 10:49 AM
  4. Decimal Places
    By momodoujimnjie in forum Access
    Replies: 1
    Last Post: 01-09-2013, 04:49 AM
  5. many decimal places in calculated fields
    By GordS in forum Access
    Replies: 1
    Last Post: 02-04-2009, 11:12 AM

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