• Create a new membership query with the following criteria:

      Current, Standing equals Active

    • Run the query.

    • Save and close the query.

    • Create a new Membership Export in Comma Separated Values (CSV) format.

    • Select the query created from the previous steps on the General tab.

    • On the Output tab, select the following fields:

      Category

      Total Members

      Constituent, Constituent Information, Name

    • Export the data to Excel.

    • Open the spreadsheet in Excel and sum the column for Total Members.