[cknepprath]

I am trying to create a query that will group all the constituents who have a cumulative giving of Receipt amount GE $100k+. I am using a Constituent query, Criteria: Summary Information/Summary for Gifts/Total Receipt Amount. On the Gift Processing tab in User Options, I have Soft Credit to Both/Use amount on gift and Matching Gift apply to Donor.

My results are way off--and I know that the fewer number is not a consequence of using Receipt Amount rather than Total Amount.

Do any of you have experience with a similar type of query? I'm pretty desparate right now!!!

Thanks in advance for any assistance.

Cecily

Cecily Knepprath
Application Administrator
University of Arizona, Foundation
520-626-4590