Results 1 to 3 of 3
  1. #1
    stuartrobins is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    2

    Decimal Places when Grouping


    Hi,

    I have a query that calculates to three decimal places. I have set that fields properties as Standard and three decimal places. When I run the query all is good i.e 0.262. However when I group the query the last decimal place changes to a 0. i.e. 0.260

    Can anyone tell me why this happens and how I resolve it?

    Thanks

    Stuart

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it may be being affected by values after the 3rd character

    try using the round function rather than relying on the format properties

    e.g. round(mydecimal,3)

  3. #3
    stuartrobins is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    2
    Hi,

    Yes, that has done it. many thanks for your help.

    Stuart

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

Similar Threads

  1. Formatting for 3 decimal places
    By Triland in forum Forms
    Replies: 12
    Last Post: 01-24-2013, 10:49 AM
  2. Decimal Places
    By momodoujimnjie in forum Access
    Replies: 1
    Last Post: 01-09-2013, 04:49 AM
  3. Report decimal places
    By jackyoung2012 in forum Reports
    Replies: 1
    Last Post: 03-22-2012, 12:12 PM
  4. Limiting decimal places
    By Cran29 in forum Access
    Replies: 13
    Last Post: 01-08-2011, 08:01 AM
  5. Changing decimal places
    By stupesek in forum Reports
    Replies: 12
    Last Post: 09-01-2010, 11:33 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