iif in Detail

[rschultz]

I have the iif statement listed below in the ControlSource of a text box in the detail band of a report, and I keep getting a Runtime error 3075 syntax error (Comma). I've used iif statements before and I pasted this one in a query and it ran and gave me the correct results. What's the secret to get it to run in a report?

iif([Prod_List] like "*Compact",[Weigh_Net],0)

 

[Rich]

Put it in the query that the report is based on.

 

[rschultz]

Pat:That was it. I can't believe it was that simple. I was so close<g>.

Now, one more step if you will. I have this formula in the ControlSource of the textbox called Text99:

=IIf([Prod_List] Like '*Compact',[Weigh_Net],0)

and I need to sum it in the group footer. I tried =Sum([text99]) but I get an, "Enter Parameter Value" box popping up when I run the report. Isn't this the same thing you told me to do in the previous message? How can I sum the textbox?