- Go to Data Management > Query
- Choose to create a new query
- Name the query and create it
- Choose the Field Type to be Transaction Information
- Choose the Field to be Lifetime amount
- Add a field clause and make it = 0
- Now save your query and run it.
Connect and collaborate with fellow Blackbaud users.