This is my third attempt to post a question...I get an error message every time...

Options
How do i query and get results showing all constituents with zero gifts. We have quite a few people who were inported for reasons not known by anyone who have no gifts. We are trying to clean up the database.

i have tried total gifts = 0 and total amount of gifts = $0.

i have also tried gift amount = blank

Thank you

Marcia Reed

Donor Services Manager

Santa Barbara City College Foundation

Comments

  • Holly Herbert
    Holly Herbert Blackbaud Employee
    Ancient Membership 500 Likes 100 Comments Name Dropper
    Marcia, I'm so sorry you are getting error messages when you try to post. If this happens again, can you send me a message and let me know? I want to make sure I understand any issues that might be occuring in the community.



    Thanks!



    Holly

    Raiser's Edge Community Manager
  • Unless we're both missing something the criteria you're listing should work.  Can you give us more details on what results you are getting?



    Try a Constituent Query > Summary Information > Tota Number of Gifts > Less than 1.
  • Sorry to ask what might be an obvious question, but are you doing a Constituent Query or a Gifts Query? If you just run a Gifts Query I woudn't expect it to show up (m)any results, but running a Constituent Query (where the gifts either =0 or, are between -0.01 and 0.01) should work.

    Matt

Categories