Recurring Gift Constituent Query

Rebekah Bushey

Hello,

I want to write a query that finds all my donors who have an active recurring gift and 0 recurring gift payments >$0 to that recurring gift.  I have donors who have a recurring gift #1 that is cancelled and payments >$0 to recurring gift #1 and also recurring gift #2 with multiple $0 payments and no payments >$0 to recurring gift #2 and I am trying to query those.

Thanks

JoAnn Strommen

Rebekah Bushey:

Hello,

I want to write a query that finds all my donors who have an active recurring gift and 0 recurring gift payments >$0 to that recurring gift.  I have donors who have a recurring gift #1 that is cancelled and payments >$0 to recurring gift #1 and also recurring gift #2 with multiple $0 payments and no payments >$0 to recurring gift #2 and I am trying to query those.

Thanks

Rebekah,  Are you trying to create 3 separate queires or one?  Are the recurring gift recrods for donors with cancelled recurring gifts marked as completed or terminated?  Or do they still have active status?

More info would be helpful to me...