If Then Statement

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I have an if then but it does not work,
If the transfer agent is NEF, PPS ,PPA put the Gross
Amount else 0 but it populates everything. Can anyone see
what is wrong? THANKS!

AnnuityFund: IIf([TRANSFER_AGENT]="NEF" Or "PPS" Or "PPA",
[WHLSLR_GROSS_AMOUNT],0)
 
Try the following, Heather

AnnuityFund: IIf([TRANSFER_AGENT]="NEF" Or [TRANSFER_AGENT]="PPS" Or
[TRANSFER_AGENT]="PPA",
[WHLSLR_GROSS_AMOUNT],0)


hth,
 
Back
Top