1. In Reports, create a new Membership Statistics by Category report from Membership reports

2. On the general tab, input the specific date range

3. Click the 'Include only active memberships in 'Memberships as of' box on the General tab. 

4. If you need a query of specific records, mark the 'Create an output query' checkbox on the General tab. Use the drop down to select either a Constituent , Membership, or Gift output query

OR



Create a query of active members (only finds currently active members)