So what is the data type of the membership field?
And why would you expect to be able to do an IIF( ) on a field that doesn't exist?
*READ* the instructions:[quote]
Add a calculated field named Monthly Fee Status as the last column
that equals active if the membership field is equal to Active and equals Not Active otherwise.
membership is the *EXISTING* field, according to that.
would be my *guess*. But that's only if membership is indeed some kind of text field.
SELECT ..., IIF( membership = 'Active', 'Active', 'Not Active' ) AS [Monthly Fee Status] ...
If you don't know what data types are and mean, time to find out.