AnsweredAssumed Answered

filter parent and child

Question asked by PeterCortiel on Oct 22, 2018
Latest reply on Nov 6, 2018 by PeterCortiel

I have a parent table and a child (Donors -> donations)

 

I need to report all donors who have not yet donated

 

like:

 

where year(deposit_date) = current year and sum(donations)=0

 

how can I do that?

donors:

donors_id,name ....

donations:

donations_id,fk_donors_id,deposit_date, amount ....

 

Action:

send a letter to all donor who have not yet contributed (as excel or delimited text file) to be used in word mail merge

Outcomes