Calculation fields

[Viv1]

Hi,

I have a form which contains the fields SUBSCRIPTIONS, VAT and TOTAL_BALANCE. The VAT field is worked out using the value in the SUBSCRIPTIONS field and the total of the 2 is shown in TOTAL_BALANCE. The problem is that the VAT is more often than not using 3 digits after the decimal point e.g. £12.325. This is shown as £12.33, however when calculations are made using the data they show figures such as -0.05 or -0.01. Is there anyway to set the database to use only 2 digits after the decimal place? I have tried setting the Decimal Places property to '2' but this behaves in the same way as Auto. Any suggestions welcome!

Thanks, Viv

 

[MacCaillean]

Hi Viv

Use the Round function ...

TOTAL_BALANCE=[SUBSCRIPTIONS] + Round([SUBSCRIPTIONS]*0.175,2)

Hope this helps

Mac

 

[Viv1]

I'm giving it a go thanks!

 

[GummowN]

I would advise against using the round function. It users bankers rounding to round the number, and as such can cause problems if you are looking at distinct numbers instead of a group.

I would use:

(int((X*100)+0.5))/100

as it produces a consistant result.

If at first you don't succeed, try

http://www.tek-tips.com

for the answer.