Query Formula Question

Question

Hi:&nbsp; I have a simple database.&nbsp; I want to display all current members and all members who have prepaid.&nbsp; The date fields in the image is working as I like.&nbsp; Now, I want to remove Deceased members and ensure only Active members are returned in the query.&nbsp; This is not working.&nbsp; I am still getting Deceased members and non active members in my query.&nbsp; What am I doing wrong?&nbsp; &nbsp;

arnel_gp · Answer

check the FieldType of Active and Deceased fields. Are they all Yes/No field?

xps35 · Answer

Your criteria select members that(are active and not deceased) OR meet date condition1 OR meet date condition2I 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 sectionTrue, False, blank, Year(Date())True, False, &gt;Date(), blank

karl_donaubauer · Answer

Hi,
&nbsp;
If you don't succeed then go to the SQL view of the query and copy the current SQL text into your next message here.
&nbsp;
ServusKarl************Access NewsAccess DevCon

harold_weyburn · Answer

Thank You. It works

Forum Discussion

Query Formula Question

Share

Resources