Products A-Z All Services Can't find what you're looking for? Chat Live!
Products A-Z Can't find what you're looking for? Chat Live!
Can't find what you're looking for? Chat Live!
HELP!
I am trying to run a list of donors who gave between 7/1/97 and 6/30/05 then DID NOT give between 7/1/05 and 6/30/07 but then DID give again between 7/1/07 and 6/30/08. I can't figure it out.
I have tried queries, comparative reports, LYBUNT, SYBUNT. My problem is that I don't know how to build crystal reports.
Any suggestions?????
Thank you!!!!!!!
This is actually not difficult to do at all and only takes one query using 3 instances of the summary information - total amount field
Total amount greater than $.01 filtered on gift date between 7/1/97 and 6/30/05AND Total amount = 0 filtered on gift date between 7/1/05 and 6/30/07AND Total amount greater than $.01 filtered on gift date between 7/1/07 and 6/30/08
Remember to also use gift type filters in each if you only want cash, etc.
THANKS!!!!
I think this worked. I was going at it in reverse and it just wasn't working!!!!