Calculation in Query - Access is upsetting me

[matydad77]

I have been racking my brain trying to some up with an answer that I just can not seem to find. I am not even sure this is the right forum but I would hope you folks can help me anyways


The question is below
"Create a query to display all matching records from the tblProgram and tblMember tables, selecting the Program Type and Monthly Fee fields from the tblProgram table and the FirstName and LastName fields from the tblMember table."
The problem I am having is it is asking me to add a calulated field named MonthlyFeeStatus as the last column that equals active if the Membership Status field is equal to active and equals not Active otherwise.
The formula I came up with is: MonthlyStatus: IIf(IsNull([MembershipStatus]),[Active],[Inactive]).
This formula is asking me to enter a parameter value of "Active" or "InActive". It does not matter what I put in the first field but it copies exactly what I put in the second. If I put abc in the field that is what it will show. Anybody have any suggestions on what I am doing wrong??

[June7]

Try:

MonthlyStatus: IIf(IsNull([MembershipStatus]), "Active", "Inactive")

[] define field or object names

Use "" for literal text.

[matydad77]

I tried that and of course it did not work for me. The only thing it returned was Inactive in the required field

[June7]

Then MembershipStatus is never null. Is it a Yes/No type field?

IIf([MembershipStatus]=True, "Inactive", "Active")