Results 1 to 3 of 3

Thread: Rounding Error Problem In Access

  1. Feb 12th, 2006, 12:04 PM #1
    Tayewo
    Tayewo is offline

    Thread Starter
    Member
    Join Date
    Nov 2000
    Location
    Lagos, Nigeria
    Posts
    50

    Rounding Error Problem In Access

    I'm using Access 97 and I have been having problem with rounding error in my reports. I later found a solution to it with something like this: Sum(Int(Abs(variable)*100+0.5)/100). This worked perfectly untill the operating system (Windows XP)was reinstalled. Now the report does not come up. Instead I get an error message from Access asking whether to "Send Report" or "Don't Send Report"
    Please, what do I do?
    Thanks.
    Reply With Quote Reply With Quote
  2. Feb 13th, 2006, 06:42 AM #2
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Rounding Error Problem In Access

    have you tried the format function
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  3. Feb 13th, 2006, 07:56 AM #3
    Tayewo
    Tayewo is offline

    Thread Starter
    Member
    Join Date
    Nov 2000
    Location
    Lagos, Nigeria
    Posts
    50

    Re: Rounding Error Problem In Access

    I've used Format but no satisfactory result.
    What I don't understand is why it has been working since August 2005 only to fail in Febrary 2006.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width