Welcome to SPN

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

Sign Up Now!

Turn off round function in Tables

Discussion in 'Information Technology' started by Beatrix, Oct 26, 2005.

  1. Beatrix

    Beatrix
    Expand Collapse
    Guest

    Dear All!
    My VAT row is rounding 16,66 to 17 automaticcally.
    It is set up as:
    number
    long integer
    2 decimal places
    required: no
    indexed: no

    Please help me, this sw is not worth anything with this wrong VAT row.

    Thank you,
    Beatrix
     
  2. Loading...

    Similar Threads Forum Date
    SciTech B-School Startup: Turning Coffee Grounds Into Food Breaking News Sep 2, 2013
    SciTech Stephen Hawking: doctors offered to turn off life support 27 years ago Breaking News Jul 30, 2013
    India School buses turning ‘Yellow Coffins’ in Punjab but who's bothered Breaking News Mar 4, 2013
    Sikh News Ontario Police Review Arrest Of Sikh Man Whose Turban Wasn't Returned - CTV News Breaking News Jul 16, 2016
    Movies Ashdoc's short movie review---Tanu weds Manu returns Theatre, Movies & Cinema Jun 6, 2015

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    Change the type from Long to Double or single

    Long and Integer will round the Number
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Beatrix" wrote:

    > Dear All!
    > My VAT row is rounding 16,66 to 17 automaticcally.
    > It is set up as:
    > number
    > long integer
    > 2 decimal places
    > required: no
    > indexed: no
    >
    > Please help me, this sw is not worth anything with this wrong VAT row.
    >
    > Thank you,
    > Beatrix
     
  4. Rich Wills via AccessMonster.com

    Guest

    Set the field to "Decimal" with "Precision" = however many digits >1 and
    "Scale" = however many digits <1

    This should resolve it but I honestly haven't used it much myself so I don't
    know if this has any affect on calculation side of things!?!

    Hope all goes well though. Let me know would be interesting to find out!

    Rich


    Beatrix wrote:
    >Dear All!
    >My VAT row is rounding 16,66 to 17 automaticcally.
    >It is set up as:
    >number
    >long integer
    >2 decimal places
    >required: no
    >indexed: no
    >
    >Please help me, this sw is not worth anything with this wrong VAT row.
    >
    >Thank you,
    >Beatrix



    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200510/1
     

Share This Page