IFF (In A Querry)

[Guest]

(In A Querry)I need to add a calculated field named MonthlyDue (Caption
property value Monthy Due) I need to use the IFF fuction to set the Monthly
due feild value to monthlyFee value for MembershipStatus field value of
active and to zerp in all other cases. can anyone help me with this?

Octet32

 

[BruceM]

I think you are looking for the IIf function. It may something like:

MonthlyDue: IIf([MemberStatus] = "Active",10,0)

This could appear in a text box formatted for Currency. This assumes
MemberStatus is a text field and that the monthly fee is $10. There are
several approaches, depending on the situation.

See Help for more about the IIf function. If you still have questions, post
details.

 

[Guest]

Thanks

I think you are looking for the IIf function. It may something like:

MonthlyDue: IIf([MemberStatus] = "Active",10,0)

This could appear in a text box formatted for Currency. This assumes
MemberStatus is a text field and that the monthly fee is $10. There are
several approaches, depending on the situation.

See Help for more about the IIf function. If you still have questions, post
details.

(In A Querry)I need to add a calculated field named MonthlyDue (Caption
property value Monthy Due) I need to use the IFF fuction to set the
Monthly
due feild value to monthlyFee value for MembershipStatus field value of
active and to zerp in all other cases. can anyone help me with this?

Octet32