Summing certain records

[kilobyte]

Is there a way to add criteria to the Sum() function? I would like to have two seperate totals in a section footer. Which total each record is calculated into should depend on a value in one of the fields. Does any one know a way to do that?

 

[RuralGuy]

You may have to explain the details of the problem further. I, for one, am not sure what you mean.

 

[Rich]

=Sum(Iif([MyField]=6,[MyField],0))

 

[kilobyte]

Aha. That should do it. Thanks Rich.

ps. Sorry I didn't explain well.