Hi
You need to give more information about how you decide if someone is activie
or not.
ie.
If say someone is only activie for the 1st year after they joined you could
have something like
IsActive:IIf (DateDiff("d", [JoinedDate],Date())>365, "Not Active", "Active")
It may be that they have to pay a certain amount each year so you could have
something to see if they have paid the correct amount,
etc
etc
If you let us know the criteria for active/not active then someone should be
able to help