IIF statement, proper formula

[jligue via AccessMonster.com]

Not entirely sure if the IIF statement is the correct way to go about this, I
have a field on a query that has total pounds of either printed or plain
product. I want to add a column to my query that only adds up the printed
product.
So, if "product type" is like printed, then add up a total, is basically what
I am
trying to say.
Can you help me with the proper formula?

 

[Allen Browne]

Assuming you have:
- a Text field named product type
- a Number field named pounds
put a text box in the Report Footer section, and set its Control Source to:
=Sum(IIf([product type] Like "*printed*", [pounds], 0))