Creating query with Calculated Field

  • Thread starter Thread starter Princessa
  • Start date Start date
P

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

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]
 
Back
Top