P
Penstar
I am putting a control in the footer of my subform as follows:
=Sum([sale])
Which relates to a calculated field in my subform, details as follows:
Control Name "Sale"
Control Source
"=IIf([qty]>0,DLookUp("TotalMatCost","QuoteDetailCostQuery","QuoteDetailID="
& [Detailid])*([margin]+1)+[labourrate],0)
I can't understand why it won't add these values and I get a #Error.
=Sum([sale])
Which relates to a calculated field in my subform, details as follows:
Control Name "Sale"
Control Source
"=IIf([qty]>0,DLookUp("TotalMatCost","QuoteDetailCostQuery","QuoteDetailID="
& [Detailid])*([margin]+1)+[labourrate],0)
I can't understand why it won't add these values and I get a #Error.