Members by Member Type and Expire Date with Dues Renewal Record Query

This query returns a list of individuals by member type with dues renewal records (batch process) by expiration date.

Query Parameters

Parameter	Description
Member Type Is Equal To	Select a member type from the drop down list.
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.
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 Name	Lists the individual membership product name.
DuesRenewalTransaction Amount	Lists the dues renewal transaction amount.