Results 1 to 2 of 2
  1. #1
    jackyoung2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    14

    Report decimal places

    Hi,

    I have built a report that displays the average value from a group of scores (0-5) but when I run the report one of the values keeps showing multilpe decimal places. I tried changing the number of decimal places in the property box to 1 but this doesn't seem to work!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    The value is result of some sort of calculation or function? The result might actually be a string instead of a number in which case the property setting will have no affect.
    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: 0
    Last Post: 01-30-2012, 01:20 PM
  2. I'm Losing Decimal Places on Currency Values
    By MichealShinn in forum Queries
    Replies: 17
    Last Post: 01-26-2012, 03:56 PM
  3. Limiting decimal places
    By Cran29 in forum Access
    Replies: 13
    Last Post: 01-08-2011, 08:01 AM
  4. Changing decimal places
    By stupesek in forum Reports
    Replies: 12
    Last Post: 09-01-2010, 11:33 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