- From Analysis, click Query
- Click Add ad-hoc query
- Select Revenue as the query type
- On the Select Filter and output fields tab, drag Transaction Type to 'include records where'
- Select one of recurring gift, pledge.
- In the same middle section, scroll down to Credit card section
- Drag Card number on to 'include records where' select Not Blank
- Add any additional fields to the output, like Constituent Name and credit card expires on
- Click Preview Results
Connect and collaborate with fellow Blackbaud users.