IIF function

[JJ]

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.

 

[fredg]

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

 

[John W. Vinson]

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

 

[JJ]

Its asking me to enter a parameter value for membership.
--
jj

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

 

[BruceM]

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

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