Query Formula Question

Hi:  I have a simple database.  I want to display all current members and all members who have prepaid.  The date fields in the image is working as I like.  Now, I want to remove Deceased members and...