Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    rounded figures in query (Access 2000)

    How can i make rounded figures in the query? In the field properties a have made decimal places to be 0, but inspite of that some of the figures are not rounded.

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

    Re: rounded figures in query (Access 2000)

    You must also set the Format property to Fixed.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: rounded figures in query (Access 2000)

    That you.Now the figures are rounded..But why in the query the figures are all right, while in the list box based on that query, the figures are two zeroes,for example 100,00 instead of 100 ?

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

    Re: rounded figures in query (Access 2000)

    So why don't you want two decimals in the list box?

Posting Permissions

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