Restricting Query Output

Alexandra Logan

Hi everyone!

I've been tasked to create a new query that lists the top 20 donors my organization has had in the last decade. I have the query created, but it just gives me summary of all of the donors who have donated in 10 years. How to I get the results to just show the 20 constituents instead of all of the donors?

Thank you in advance!

Dana Burton

Hello Alexandra! Here are a couple options you can check out.

How to query or report to find the top X number of largest gifts in the database

https://kb.blackbaud.com/knowledgebase/Article/41357

What is the Top Donors Report and how do I run it?

https://kb.blackbaud.com/knowledgebase/Article/41403

Alexandra Logan

This is PERFECT! Thank you so much Dana ?