Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    rounding to whole number (97 sr2)

    I am doing an average on three months. I need the answer to round to the whole number. I am calculating the average in a query and printing it on a report. I would appreciate any help, I am lost. When I use the Rnd function it rounds the decimal places.

    Thanks again you guys are great!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: rounding to whole number (97 sr2)

    Set the Format property of the text box that displays the average on the report to Fixed, and the Decimal Places property to 0. No need to use functions.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: rounding to whole number (97 sr2)

    That was so easy I should be ashamed. thanks so very much.

    Cathy

Posting Permissions

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