Members by Member Types and Expire Date with Chapter Affiliation Query

This query returns a list of individuals by member types with chapter affiliation by expiration date.

Query Parameters

Parameter	Description
Product Is Equal To	Select a product from the drop down list.
Member Flag Is Equal To	Select a member flag from the drop down list: Member, Non-Member, All.
Expire Date Greater Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.
Expire Date Less Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Individual Sort Name	Lists the individual sort name.
PriAddr Address Line 1, 2, 3, City, State/Territory, Postal Code	Lists the individual primary address.
PriPhone Phone Number	Lists the individual primary phone number.
PriFax Fax Number	Lists the individual primary fax number.
PriEMail E-Mail Address	Lists the individual primary email address.
membership Join Date	Lists the individual membership join date.
membership Effective Date	Lists the individual membership effective date.
membership Expire Date Member	Lists the individual membership expire date.
Member Status	Lists the individual member status.
MemPrd Product Code	Lists the individual membership product code.
cat Chapter Affiliate Name	Lists the individual chapter affiliate name.
cat Chapter Affiliate Description	Lists the individual chapter affiliate description.
cat Chapter Affiliate Type	Lists the individual chapter affiliate type.