R
Roland
I am trying to run a report that generates invoices for various households,
currently only 1 of the households requires their invoice to be split by
department.
In the department header, I have the following textbox
=IIf([HouseholdNumber]=1,"Department: " & [Department],"")
I have now been asked that a second household also wants their invoice split
by department and am having difficulty nesting 2 IIf statements and have
tried the following to no avil
=IIf([HouseholdNumber]=1,"Department: " & [Department],"") And
IIf([HouseholdNumber]=7,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " & [Department],"") Or
IIf([HouseholdNumber]=7,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " & [Department],""),
IIf([HouseholdNumber]=1,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " IIf([HouseholdNumber]=7,"Department:
" & [Department],"")
In the department footer, I also need to update the following textbox's to
also show HouseholdNumber 7
=IIf([HouseholdNumber]=1,"Total Payment Due (exc. VAT):","")
=IIf([HouseholdNumber]=1,"VAT @ " & Format([VatRate],"#.#%") & ":","")
=IIf([HouseholdNumber]=1,"Total Payment Due (inc VAT):","")
=IIf([HouseholdNumber]=1,Sum(Vehicle_Total(Monthly_Total([MonthlyRental]+[AccessoryCharge],[VatRate]),[TotalMonths])),"")
=IIf([HouseholdNumber]=1,([txtDeptMinusVAT]*[VatRate]),"")
=IIf([HouseholdNumber]=1,[txtDeptMinusVAT]+[txtDeptVAT],"")
Many thanks in advance for any help/advice
currently only 1 of the households requires their invoice to be split by
department.
In the department header, I have the following textbox
=IIf([HouseholdNumber]=1,"Department: " & [Department],"")
I have now been asked that a second household also wants their invoice split
by department and am having difficulty nesting 2 IIf statements and have
tried the following to no avil
=IIf([HouseholdNumber]=1,"Department: " & [Department],"") And
IIf([HouseholdNumber]=7,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " & [Department],"") Or
IIf([HouseholdNumber]=7,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " & [Department],""),
IIf([HouseholdNumber]=1,"Department: " & [Department],"")
=IIf([HouseholdNumber]=1,"Department: " IIf([HouseholdNumber]=7,"Department:
" & [Department],"")
In the department footer, I also need to update the following textbox's to
also show HouseholdNumber 7
=IIf([HouseholdNumber]=1,"Total Payment Due (exc. VAT):","")
=IIf([HouseholdNumber]=1,"VAT @ " & Format([VatRate],"#.#%") & ":","")
=IIf([HouseholdNumber]=1,"Total Payment Due (inc VAT):","")
=IIf([HouseholdNumber]=1,Sum(Vehicle_Total(Monthly_Total([MonthlyRental]+[AccessoryCharge],[VatRate]),[TotalMonths])),"")
=IIf([HouseholdNumber]=1,([txtDeptMinusVAT]*[VatRate]),"")
=IIf([HouseholdNumber]=1,[txtDeptMinusVAT]+[txtDeptVAT],"")
Many thanks in advance for any help/advice