Sum(IIf()) Help

[Guest]

=Sum(IIf([OrderDetails Subform].[Description] Like "Deilvery" Or
[OrderDetails Subform].[Description] Like "Carriage",[OrderDetails
Subform].[ExtendedPrice],0))

I'd like to sum the field ExtendedPrice when the field Description contains
"Delivery" OR "Carriage". Both fields are in the subform [OrderDetails
Subform]. The above code was entered as the control source for a text box on
the main form. #Error is displayed when the form is opened.

Any ideas where I've gone wrong?

Thanks

Dave

 

[Guest]

Try using

=Sum(IIf(Forms![NameOfMainForm]![OrderDetails Subform].Form![Description]
Like "Deilvery" Or Forms![NameOfMainForm]![OrderDetails
Subform].Form![Description] Like
"Carriage",Forms![NameOfMainForm]![OrderDetails
Subform].Form![ExtendedPrice],0))

Hope this helps.