S
SG
I have a form called frminvoice on this form I have the following three text
boxes....
SUB Total , Control source
=IIf(IsNull([Total]),Null,IIf(Nz(VAT.Column(1),0)=0,Null,CCur(Round([Total]/(VAT.Column(1))))))
VAT Total , Control Source =IIf(IsNull([Sub
Total]),Null,nz([Total],0)-nz([Sub Total],0))
Total, Control Source =InvoiceSubForm.Form!OrderSubtotal
This work well on the form but I have an invoice report but I can not get
the above to work, any suggestions?
Many Thanks
S
boxes....
SUB Total , Control source
=IIf(IsNull([Total]),Null,IIf(Nz(VAT.Column(1),0)=0,Null,CCur(Round([Total]/(VAT.Column(1))))))
VAT Total , Control Source =IIf(IsNull([Sub
Total]),Null,nz([Total],0)-nz([Sub Total],0))
Total, Control Source =InvoiceSubForm.Form!OrderSubtotal
This work well on the form but I have an invoice report but I can not get
the above to work, any suggestions?
Many Thanks
S