Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    6

    Unanswered: Rounding in Query

    Hi,

    I have a calculated field in a query set to zero decimal places. When I run the query the output is as expected, but when I export the query results to excel, the rounding is no longer there.

    Is there a way to keep the result rounded to zero decimal places for exporting?

    Thanks.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Use the Round() function in your calculation.
    Paul

  3. #3
    Join Date
    May 2012
    Posts
    6
    Quote Originally Posted by pbaldy View Post
    Use the Round() function in your calculation.
    Excellent, thank you.

  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
  •