sum iff

[steve111]

hi ,

I have a report that sums all my costs for work done or forecast to be done
= sum([cost])

what I would like to do is also just sum the costs that are forecast to do
I have a field called " completedtasks" that is a tick box ( yes/no)

how can I ask it to sum the cost for all the ones that does not have the tick against it

thanks steve

 

[Brianwarnock]

Sum(IIf(checkboxname=FALSE,[cost],0))

Brian