Hello,

I was wondering if anyone knows how to create a constituent query that will pull last gift to a specific campaign. For example, we want to pull a list together of everyone who has contributed to our direct mail campaign and what their last gift and amount were to that campaign. But we just had our annual dinner and auction. So we can't query on last gift as their last gift may have been to our dinner and auction, not to our direct mail campaign. We need to merge this query with other queries, so last gift to our direct mail campaign has to be part of the criteria, not just the output. Is this even possible to pull a constituent query in RE based on last gift to a specific campaign rather than just last gift? 

Normal 0 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

Thanks,

Erica Peters

Annual Campaign Coordinator

Senior Services, Seattle

Erica - If you use EXPORT, you can filter the Last Gift field by specific campaign/fund/appeal etc.

Thank you, Tracie. That worked out perfectly.

 Erica

Glad to help! :)