If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invoice Report
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 |
#2
|
|||
|
|||
Invoice Report
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. "SG" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|