I want to create a query that will show me the names with "Date of Payment" of a week ago and that is not paid yet (so, not marked on the yes/no field).
So I open the query and I will see where date of payment is today until 7 days ago.
If the field Paid is marked, do not show.
The problem is that when I create this criteria for Date of Payment 1 and Paid 1, the program ignores Date of Payment 2. If Paid 1 is marked it doesn't show anything. But if Paid 1 is marked, the program should use the criteria for Date of Payment 2 and Paid 2, until everything is paid. So it's an OR criteria not AND.