Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    17

    Unanswered: Limiting Decimal Places in a Calculated Query Field

    I'm trying to display the results of a query in a stacked bar chart, and the numbers (in the tens of thousands) are too large. I tried dividing them by 1,000 to make them smaller, but now the decimal places make up the spaces. In some cases the decimals repeat for as many as seven spaces.

    I tried opening the query in design form, clicking the calculated field, and setting Properties > General > Decimal Places > 2.

    It doesn't do anything.

    Any ideas?

    Thank you!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    How about the Round() function?
    Paul

  3. #3
    Join Date
    Aug 2011
    Posts
    17

    That did it! Thanks.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help!
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •