Turn off round function in Tables

[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

 

[Guest]

Change the type from Long to Double or single

Long and Integer will round the Number

 

[Rich Wills via AccessMonster.com]

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