Forum Discussion
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...
Your criteria select members that
(are active and not deceased) OR meet date condition1 OR meet date condition2
I think what you want is all members that
(are active and not deceased and meet date condition1) OR
(are active and not deceased and meet date condition2)
So make two lines on the criterion section
True, False, blank, Year(Date())
True, False, >Date(), blank