Report Sum

[rschultz]

I have the following code in a texbox called "Compact" :

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

Thanks to Pat it's working fine. But in the [Date] footer, I tried to sum that textbox with

=Sum([Compact])

but I get an 'Enter Parameter Compact' box. I know I've done this before, what am I doing wrong?

 

[rschultz]

as soon as I saw your answer I remembered. Thanks again