Search results

  1. B

    Sum (iff) with multiple strings issue

    Accurate assessment! I appreciate the extra help! Thank you!
  2. B

    Sum (iff) with multiple strings issue

    Thank you! That makes sense and worked alot better! I will look into the unnormalized database issue. Thanks again!
  3. B

    Sum (iff) with multiple strings issue

    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...
Back
Top Bottom