Sum in Report

[bethabernathy]

Hi - I am having a little trouble. I want to put together a calculation in a text box on a report. I want to Sum the value of "pmt_amt" if the value in the field "passstat" = "RFND"

So, I am clearly lost. Any suggestions?

Thanks so much.

Beth beth@integratedresourcemgmt.com

 

[JerryDennison]

In an unbound control in your report's footer or header use the following:

=Sum(IIF([passstat] = "RFND", [pmt_amt], Null))