Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding Error On Report (Access 2002)

    I have a report that grouping where I sum fields; I'm experiencing rounding errors. The $2.02 + $4.54 = $6.57; how can that be?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Error On Report (Access 2002)

    I can't reproduce the error in Access 2000.
    What is the result if you use :
    =Round([textbox1],2)+Round([textbox2],2)
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Error On Report (Access 2002)

    Thanks for the response; but that's the display of the records. My true issue is that I have used percentages to multiply a amount. So the field is displayed as such but it could rally be $2.0245 and $4.54466. My actual problem is how do you store numbers with just two decimals?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Error On Report (Access 2002)

    In the after update of the textbox('s) or in the before update of the form, you could use
    Me.Textbox1 = Round(Me.Textbox1,2)
    Francois

Posting Permissions

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