iif function

[santastefano]

I have a report that uses the iif function to enter two currency amounts depending on the state of a check box in the underlying query.

=IIf([Private]=True,!NumberStudents*[Tuition],[Tuition])

This works fine and I am able to total the amount in each row

[field]+[field]

I can not make the individual columns total using the conventional

=sum([fieldname])

Any suggestions gratefully received.

 

[santastefano]

Whoops!!
Now found the stupid error that caused the problem - as always if done properly it functions OK.