IIF function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJ - 20 Feb 2008 17:35 GMT

Please help me set up the following calculated field. Need a calculated
field that equals Active if the MembershipStatus field is equal to Active and
equals Not Active otherwise.

Signature

Reply to this Message

fredg - 20 Feb 2008 17:48 GMT

> Please help me set up the following calculated field. Need a calculated
> field that equals Active if the MembershipStatus field is equal to Active and
> equals Not Active otherwise.

NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

JJ - 20 Feb 2008 18:05 GMT

Its asking me to enter a parameter value for membership.

Signature

> > Please help me set up the following calculated field. Need a calculated
> > field that equals Active if the MembershipStatus field is equal to Active and
> > equals Not Active otherwise.
>
> NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")

Reply to this Message

BruceM - 20 Feb 2008 19:04 GMT

Where did membership come from? Is it the same as MembershipStatus? If so,
are there any criteria for the field? In any case, is it spelled correctly?
Is this in a form or in a report? If it is in a report, add a
MembershipStatus text box to the report. Make it invisible if you wish.

> Its asking me to enter a parameter value for membership.
>
[quoted text clipped - 5 lines]
>>
>> NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")

Reply to this Message

John W. Vinson - 20 Feb 2008 17:57 GMT

>Please help me set up the following calculated field. Need a calculated
>field that equals Active if the MembershipStatus field is equal to Active and
>equals Not Active otherwise.

IIF([MembershipStatus] = "Active", "Active", "Not Active")

Signature

John W. Vinson [MVP]

Reply to this Message