Table "Members" contains a list of subscribers over the last 10 years. Some subscribers cancelled their subscription, but subscribed again at a later date. In this case, there are two records for that subscriber. One record contains the date of the cancellation in the field "DateUnsubscribed", the other record as a null in the field "DateUnsubscribed".
Each record contains multiple fields, but the ones I believe are of importance are:
Email and DateUnsubscribed (which is null in the case of an active subscriber).
I want to send a special offer to those subscribers who are not currently subscribed.
The database is MS ACCESS.