IIF function

  • Thread starter Thread starter JJ
  • Start date Start date
J

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.
 
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.
Click to expand...

NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")
 
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.
Click to expand...

IIF([MembershipStatus] = "Active", "Active", "Not Active")
 
Its asking me to enter a parameter value for membership.
--
jj


fredg said:
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.
Click to expand...

NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")
Click to expand...
 
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.

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


fredg said:
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.
Click to expand...

NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")
Click to expand...
Click to expand...
 
Back
Top