I need help using the IIF function

[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.

 

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

 

[Jeff L]

Try this:

MonthlyDue: IIF(MembershipStatus = "Active", [MonthlyFee], 0)