Can anyone help?
I have within my database a calculation in macro form eg. Action: SetValue. Item: [CSP]. Expression: Ccur([CSGP]/[CST]) on my form for storing calculations in a field.
And place in OnCurrent for Form properties and AfterUpdate for fields CSGP & CST.
Unfortunately the CSGP & CST fields will from time to time contain a zero how do I overcome the Overflow and Action failed error the macro produces.
I have within my database a calculation in macro form eg. Action: SetValue. Item: [CSP]. Expression: Ccur([CSGP]/[CST]) on my form for storing calculations in a field.
And place in OnCurrent for Form properties and AfterUpdate for fields CSGP & CST.
Unfortunately the CSGP & CST fields will from time to time contain a zero how do I overcome the Overflow and Action failed error the macro produces.