S
SG
I have a texy box with the following control source
=IIf(IsNull([SubTotal]),Null,CCur(Round([SubTotal]/(VAT.Column(1))))) which
works fine but if there is nothing in the field I get the following #Num!
how can I stop this?
Thanks in advance.
S
=IIf(IsNull([SubTotal]),Null,CCur(Round([SubTotal]/(VAT.Column(1))))) which
works fine but if there is nothing in the field I get the following #Num!
how can I stop this?
Thanks in advance.
S