I need to pull a list of constituents who made a gift between 7/1/08 - 6/30/09 (our fiscal year) and who may have a match gift projected or paid totaling $1866. How would you query this?

Hello Jo lynn,

Here is how I would query on that:

Create a constituent query with the following criteria:

Summary Information, Total Number of Gifts greater than or equal to 1, on the Filter tab select:
Gift Date between 7/1/08 - 6/30/09
AND Summary Information, Total Number of Gifts greater than or equal to 1, on the Filter tab select:
Gift Date between 7/1/08 - 6/30/09
AND Gift Type equals MG Pledge
AND Gift Amount greater than or equal to $1866

Hope this helps!