Creating query with Calculated Field

[Princessa]

I am creating a query with a calculated field named MonthlyFeeStatus. This
field should equal Active if the MembershipStatus field is equal to Active
and equals Not Active otherwise. How would I set up this equation. Thanks

 

[John W. Vinson]

I am creating a query with a calculated field named MonthlyFeeStatus. This
field should equal Active if the MembershipStatus field is equal to Active
and equals Not Active otherwise. How would I set up this equation. Thanks

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

This assumes that MembershipStatus has values other than "Active" and "Not
Active"; if those are the only two, then you can simply echo the field:

MonthlyFeeStatus: [MembershipStatus]