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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query expression in a calculated field 16
Still unable to run successful query 2
IIF function 4
IFF (In A Querry) 2
Field by Field Comparison 3
Changing existing code to add "IF Statement" 7
If Function 2
Newbee 12

Back
Top