Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    UK near Blackpool

    Unanswered: Total on report not calculating correctly

    I have set up a db to produce invoices for customers. The fields at the bottom of the invoice display:-

    Vat = [subtotal]*[vatrate]/100
    Total = [subtotal]+[Vat]

    This works on most invoices ok but on some it prouduces errors due to rounding. ie a 69 subtotal gives Vat of 12.07 (based on UK 17.5%) then adds them as 81.08 ie .01p more than the correct amount.

    It is obviously due to the Vat calculation being 12.075 and access rounding the total up.

    How do I rectify this both for the report and my screen display.
    I think I may have seen this problem with vat calculations before but cannot find the relevent article.

    Any help appreciated.

  2. #2
    Join Date
    Oct 2002
    NSW Australia
    I had similar problems with access's rounding. Go here for a custom rounding module:

Posting Permissions

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