Sum function

[jcdifi26]

I am using Access 2003. In a previous post I asked about changing a
number from postive to negative. I got a reply which told me to add
this: =IIf([I-C]='C',-1,1) * [List Price] to the control of the text
box I wanted to change. I worked perfect. I am now trying to use the
Sum function in the report footer to get the sum of this text box, but
every time I use =Sum ([ListPrice]) it does not recognize ListPrice.
What am I doing wrong?

Thanks
Joe

 

[Duane Hookom]

You can't sum a control. Try:
=Sum(IIf([I-C]='C',-1,1) * [List Price])