Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Rounding

Discussion in 'Information Technology' started by hughess7, Jul 28, 2006.

Tags:
  1. hughess7

    hughess7
    Expand Collapse
    Guest

    Hi all

    I know this is a problem with Access but I'm not sure how to sort it. I have
    expense records that have the total entered and a VAT rate (default being
    1.175) by the user. In my queries calculations are performed to work out Net
    and VAT amounts, if applicable - not all are vatable. Access automatically
    rounds the numbers eg 1.235 becomes 1.24. I have another query sat on top of
    this which groups and sums the amounts. The sum of VAT is 0.05 above what the
    VAT should be if calculated on the sum of Amount. I have to calculate the VAT
    seperately though with each line not being the same rate.

    Is there a way to sort this? Do I need to use the round function I've seen
    mentioned in some posts?

    Thanks for any help.
    Kind Regards
    Sue

    --
    Thanks in advance for any help.
    Sue
     
  2. Loading...

    Similar Threads Forum Date
    Controversy Surrounding Nanakshahi Sikh Calender Sikh Sikhi Sikhism Dec 3, 2009
    Controversy Surrounding Prof Darshan Singh Ji Hard Talk Nov 14, 2009

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "hughess7" <hughess7@discussions.microsoft.com> wrote in message
    news:09C8D974-A177-4764-A956-52C1DD0F5B34@microsoft.com...
    >
    > Is there a way to sort this? Do I need to use the round function I've seen
    > mentioned in some posts?


    I would suggest that you use a custom rounding function, if the average is
    off by more than a few hundreths. The built-in one, and the currency
    datatype only round the display, which is what is causing your problem.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  4. hughess7

    hughess7
    Expand Collapse
    Guest

    I was using the format fixed on the VAT column in my query, in experimenting
    I removed this (so no rounding took place) and it adds up ok now.
    --
    Thanks in advance for any help.
    Sue


    "Arvin Meyer [MVP]" wrote:

    >
    > "hughess7" <hughess7@discussions.microsoft.com> wrote in message
    > news:09C8D974-A177-4764-A956-52C1DD0F5B34@microsoft.com...
    > >
    > > Is there a way to sort this? Do I need to use the round function I've seen
    > > mentioned in some posts?

    >
    > I would suggest that you use a custom rounding function, if the average is
    > off by more than a few hundreths. The built-in one, and the currency
    > datatype only round the display, which is what is causing your problem.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
    >
     

Share This Page