Invoice Report

[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

 

[Guest]

HI SG,

If they are giving you the results you expect, perhaps you could include
them in a query to drive your report, then just refer to the fields as per
normal?

Damian.