How to Remove Duplicates due to Tributes in General Ledger Query

Options
Wynn Shawver
Wynn Shawver
Eighth Anniversary Photogenic Name Dropper First Comment
in Blackbaud Raiser's Edge NXT®: General Discussion
Help! When we pull a query for our General Ledger reports, and our acknowledgments - we get duplicates for all gifts related to tributes due to the multiple acknowledge. Does anyone have a quick fix?


Thank you,


Wynn
Tagged:

Comments

  • John Heizer
    John Heizer
    Ancient Membership 500 Likes 500 Comments Photogenic

    Wynn Shawver:

    Help! When we pull a query for our General Ledger reports, and our acknowledgments - we get duplicates for all gifts related to tributes due to the multiple acknowledge. Does anyone have a quick fix?


    Thank you,


    Wynn

    Any Query that has output fields that might have multiple values will result in multiple rows in the output.  But you'll still only get one record saved in the Query results.  When you use that Query as a source for an Export or Report it won't get counted twice.

Categories