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

Options
Marcia Reed
Marcia Reed ✭
Tenth Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
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
Tagged:

Comments

  • Holly Herbert
    Holly Herbert Blackbaud Employee
    Ancient Membership Facilitator 2 Name Dropper Photogenic
    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
  • John Heizer
    John Heizer ✭
    Ancient Membership Facilitator 3 Photogenic
    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.
  • Matt Page
    Matt Page ✭
    Tenth Anniversary Facilitator 2 Photogenic
    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