Forms show negative

[thunderbolt1164]

I am building a db and on it forms I have:

Subtotal
Labour
GST
Total
Payment(Button)
Amount Owing

They all seem to work until I click Payment and enter the Total amount, then I get Amount Owing -0.01 or -0.02

Is there way to fix this (I think it has to do with the GST), Maybe by using an IF Statment or somthing

??(IF AmountOwing<0 THEN AmountOwing=0)??

I think i saw a 4 letter query code when adding up on another db, but now I can't find it.

My book keeper hates seeing a negative, even if not true.

Thanks for any help

 

[jackryan]

yes you can use our if-then statement

If AmountOwing<=0 then AmountOwing=0

 

[neileg]

I presume these amounts come from rounding errors. Why not round your calculations so they don't arise?