New Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields that say this:

LoanGoals: IIf([$ Loans]>=350000,"YES")
DepositGoals: IIf([$ Deposits]>=300000,"YES")

Now, in order for the loan officers to receive their bonuses, they have to
meet both loan and deposit goals.

So, can I add a third column that requires a YES to appear only if both
LoanGoals has a YES and DepositGoals has a yes?
 
I wouldn't create an expression that looks for a value of LoanGoals and
DepositGoals. Rather build an expression like:

ThirdColumn: IIf([$ Loans]>=350000 AND [$ Deposits]>=300000,"YES", "Bah
Humbug")

BTW: consider finding and sticking to a better naming convention/system. You
should also provide both True and False expressions in the IIf() function.
 
Back
Top