We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
hey guys,
i'm trying to put together a query which will filter out all tributes whose gift total up to less than $500. is there a function which can total gifts in the queries categories? thanks a bunch.
Create a Constituent query
go to Summary Information - Gift Summary - Total Amount
you can then add in the amoutn you want (less than $500) and any filters (tribute gifts)
Create a Constituent query
go to Summary Information - Gift Summary - Total Amount
you can then add in the amoutn you want (less than $500) and any filters (tribute gifts)
I don't think that's what he was asking for. This will give you constituent's who have given $500 to various tributes, not tributes that have received $500 from various constituents. I think what you actually want is to run a constituent query and go to Tributes > Summary for Tribute Gifts.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Linear Mode
