Query results display wrong Name on Card

Membership Queries can be used to gather information on members.  When including Other Members/Card Holders > Name on Card in the output, the primary member is listed as the Name on Card for other members if the other member is also a constituent.  The actual name on the additional cards needs to be in the Query results.

Use a Constituent Query with the same filters


Include your existing query of members in a Constituent Export. Select the desired fields in Output, including Membership > Cards > Name on Card. Be sure to enter an appropriate value (more than 3) in the field "For each Membership, enter the number of Cards to export.

As long as a large enough number is selected, all of the "Name on Card" information will be listed in the export spreadsheet correctly.


 Raiser's Edge

Was this article helpful?