Recent content by HankLewis

My script is running with no errors now, thank you! How do I get each row that match my criteria to Sum a total (for all that match) on ONE row? Expr1: Sum(IIf([2014 Rating]=3 And [Division Chgs to Merit %]="2.75",[Division Merit Dollars Adjustment],0)) So if I have three rows that met my...

Can you assist me with summing a field based on two qualifiers from other fields? For example Sum if '2014 Rating' = 3 and 'Division Chgs to Merit %' = 1.00% then sum 'Division Merit Dollars Adjustment'. I'm getting a syntax error when running this: Cost Detail: Sum(IIf([2014 Rating]=3 And...