Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Carol Stream, Illinois, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Currency rounding up (Access XP)

    Ok, Access newbie here... I have selected currency in my table for a field, but whenever I enter an amount that has cents, it rounds up to the nearest dollar - e.g. $72.80 becomes $73.00. Is this a global setting, or something specific to my table?

  2. #2
    Lounger
    Join Date
    Feb 2001
    Location
    Torn between Kent & Essex, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency rounding up (Access XP)

    If you go into the design view for this table, what is the decimal places property for this field? Set it to 2 or auto and see if that helps.

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    Carol Stream, Illinois, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency rounding up (Access XP)

    I've tried both "2" and "auto", but it seemed to have no affect. I also tried saving, closing, reopening, etc. I've also found that if I change the format from Currency to General Number, it still won't allow decimals. I have the field size set to Long Integer, so I have no idea what the problem is. Grrr.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency rounding up (Access XP)

    An integer has no decimal places. Change the field size to Double, or better yet select curency for the data type.

    HTH

    Peter

  5. #5
    New Lounger
    Join Date
    Oct 2002
    Location
    Carol Stream, Illinois, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency rounding up (Access XP)

    Changing to Double took care of it - thanks a ton.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Currency rounding up (Access XP)

    It is better to have it set to currency at that has underlying 4 decimal places and does not give rise to errors on calculation as double does.
    David Grugeon
    Brisbane Australia

Posting Permissions

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