If Then Statement

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)
 
C

Cheryl Fischer

Try the following, Heather

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


hth,
 
Top