There is no way in gift query to get a list of all pledges that were written off. If you need this like I do please add yourself to the list for this. Notice there are NO workarounds for this - it is simply impossible. Solution Number: BB18352 Applicable Product(s): Raiser's Edge 6 Solution Title: How to query on written off pledges This has been filed as a suggestion. While we may not implement it, we will review it for possible use in future product development. Add me to the list. Here is the problem or goal: How to query on written off pledges Problem Environment: Query S15902-111599 *** my spelling is fine, it's my typing that stinks. Where is spell check? Melissa S. Graves Manager, Development Database & Direct Mail Planned Parenthood of Connecticut [Email Removed] 203-752-2804

Added my "John Hancock" on that one. I tried running the Written Off pledge report and was able to get a gift output query of the pledges on that report. A possible workaround for what you are looking for? Cara Russell Donor Records Coordinator Hospice of Spokane (509) 456-0438 [Email Removed]

Definitely Possible. I LOVE when forum members find workarounds that BB hasn't found. I'll try it tomorrow. *** my spelling is fine, it's my typing that stinks. Where is spell check? Melissa S. Graves Manager, Development Database & Direct Mail Planned Parenthood of Connecticut [Email Removed] 203-752-2804

Melissa - When I enter the solution number you referenced below, it automatically takes me to this solution BB76960? Looks like they have come up with some workarounds now! Tracie Cassidy Database Coordinator Seattle Children's Hospital Foundation (206) 987-6833 [Email Removed]

Melissa, Maybe I'm missing something, but I just query on Gift Type = Write Off or MG Write Off. What is not working? Elaine Tucker Stewardship Coordinator St. Mark's School of Texas www.smtexas.org [Email Removed]

I need the query result to be the pledge record not the write off record. Your query would give me a result of all of the individual write offs. I need to globally change a field on the pledge gift not on the write off as your query would do. I was not able to test the Write Off Report output query workaround yet but will soon. *** my spelling is fine, it's my typing that stinks. Where is spell check? Melissa S. Graves Manager, Development Database & Direct Mail Planned Parenthood of Connecticut [Email Removed] 203-752-2804