To print membership cards for certain individuals only, you need to create a special query. This query will be used to select the members you want to print out cards for. Ideally, you should try to choose eight members to print cards for, since this will make use of the full sheet of membership cards.

First create a new user defined field by going to the Setup menu and choosing User Defined Fields. In UD_FIELD 8, type ‘Print Card.’

Now go to the Edit menu, choose Members, and select a member who you want to print a card for. Go to their Miscellaneous screen. Here you will see the Print Card field in the center right. The number 8 indicates that this is User Defined Field 8. Type the letter y in this field. Put a y in this field for each of the members you want to print a card for.  **NOTE: The letter y's must all be lower case.

Now go to the Output menu and choose Reports, Labels, Letters, then select Membership on the left side of the window, and choose Membership Cards (Sheet) from the list. Now click on the Modify button on the right and the Query Builder window will appear. Here click on the Add button to create a new query. Type in a name for the query in the upper left box – type Print Cards. The Data Source should read Members. Now click on the Field 1 button and choose User Defined Field 8 from the bottom of the list. This is the field that you named Print Card. Next click on the drop-down arrow button below Operator – choose Equal To from the list of choices (scroll to the top to find it). Now the Enter Character Value window will appear. Click on the Choices button and select y from the list and hit OK. Click OK again and then close the Query Builder window.

The Print Cards query should now appear beside the Query button in the Run Reports window. You can change the output to Printer and click on the Run button to print the cards. In the future, you can control who cards are printed for by putting a y in the Print Card field (User Defined Field 8) in the member’s Miscellaneous screen. When you print cards for those individuals, you will need to select the query Print Cards.

1/29/02