1. Create a  membership query (BB19082) 
  2. On the Criteria tab, select the following. Be sure to include the parentheses:
    Membership, Standing equals Active
    AND (Membership, Current, Joined on Date between [the date range]
    OR Membership, Current, Renew Same Date between [the date range]
    OR Membership, Current, Renew Upgraded Date between [the date range]
    OR Membership, Current, Renew Downgraded Date between [the date range]
    OR Membership, Current, Rejoin Same Date between [the date range]
    OR Membership, Current, Rejoin Upgraded Date between [the date range]
    OR Membership, Current, Rejoin Downgraded Date between [the date range])