I am attempting to sum amounts only if a different field in the same table contains a certain amount. Here is the formula I have now:
EE Pre Tax: Sum(IIf([Inelig]![P1 Source]="EE", [Inelig]![P1 Amount]), Sum(IIf([Inelig]![P2 Source]="EE", [Inelig]![P2 Amount]), 0))
I will need to do this for 15...