How do I SUM an IIf Statement? 1

[anhfuego1]

I created an IIF statement for cell named CircForPlanCalcs:

=IIf([Text285] Is Null,[Circulation],[Text285])

is the formula.

it works fine, I only need to find a way to SUM up these values that it pulled. I tried
Sum([CircForPlanCalcs]) but it recognized it as a parmater query.

Any help would be greatly appreciated!

 

[Trevil]

I assume your IIF is in a control in the detail section of your report, and the SUM is in a control in the footer?

It also appears from the names in your formula that you are referencing other controls and not fields from the recordsource?

Using fields from the recordsource would allow you to use:
=Sum(IIf([fld1] Is Null,[fld2],[fld3])


"Hmmm, it worked when I tested it....