The program is working as designed. The default value of Gift Vehicle is Bequest. Non-Planned Gifts will receive the default value in the results of query or export.
Add the following field to the Criteria:
Gift Information, Gift Type equals Planned Gift
- Add the following field to the Output:
Gift Information, Gift Type
- Once the file is exported to Excel, sort the spreadsheet by Gift Type and delete the Gift Vehicle value for all non-Planned gifts.