CiviCRM Community Forums (archive)

I need to do an export of my top 700 donors for a mailing.  I'm getting the feeling that it is not possible.

First, can I search by someone's total gifts?  I know that in the Contributions tab, it gives a sum, but I have never been able to find a way to search using that number or a field label for that figure.

Also, I don't think I can specify the number of contacts that you want in a search output, but I supposed if I were able to search by a person's total giving, I would just sort by that amount and only export the top 700.

Sarah Craft, Equal Justice USA

Sarah, If you can run this query, either in Access or PHPMyAdmin or another tool, it should start you toward your goal:

SELECT civicrm_contact.display_name, Sum(civicrm_contribution.total_amount) AS SumOftotal_amount
FROM civicrm_contact INNER JOIN civicrm_contribution ON civicrm_contact.id = civicrm_contribution.contact_id
GROUP BY civicrm_contact.display_name;

Please post back.  Access will let you do a Top NNN query...

Best,
Ken