Sum of IIF

[Hagan]

Sorry if this is a repeat, but I think I posted it in the wrong area before.

I'm trying to use an Iif function between two columns that are populated in
the db. The lines total across, but when I try to grand total them att he
bottom, I get asked for more information or get an error.

=Sum(IIf([Monthly Limit]>[Total Points],[Total Points],[Monthly Limit]))

Thanks for any and all help.

 

[Ken Snell \(MVP\)]

Are [Monthly Limit] and [Total Points] the names of fields in the report's
RecordSource query? If not, replace them with the actual field names -- Sum
will not work on controls' values.