I need help using the IIF function

T

Trice36

Can someone please help with this question.

I've created a query and I need to add a calculated field named MonthlyDue.
Use the IIf function to set the MonthlyDue field value to the MonthlyFee
value for MembershipStaus field values of Active and to zero in all cases.

I just can't figure this one out.
 
O

Ofer Cohen

I'm not sure that exactly what you need, but you can use the idea to fix it

MonthlyDue : IIf(MembershipStaus = "Active" , [MonthlyFee] ,0)
 
Top