|
| 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
December 12th, 2006, 12:47 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
|
|||
|
|||
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
December 12th, 2006, 02:09 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
|
|||
|
|||
|
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 | |
|
|
Linear Mode
