IIF statement, proper formula

  • Thread starter jligue via AccessMonster.com
  • Start date
J

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?
 
A

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))
 
Top