Create a Membership Query:
  1. In Analysis select Information Library.
  2. Click Add an ad-hoc query.
  3. Highlight the Memberships Source View and click OK.
  4. In the middle of the new ad-hoc query, select Status and move this to Include Records Where. Set the criteria to equal to Active.
  5. If you want to filter on members only in certain levels or programs, in the middle, click on Membership level or Membership Program,move this to Include Records Where and set the criteria to equal to that level or program.
  6. Under browse for fields in highlight Membership Transaction.
  7. Move Action to include records where and set this equal to the actions you want to see in your list such as join or renew. To add more than one change the drop-down menu to one of and add the actions to the right hand list.
  8. With Membership Transaction still highlighted move Transaction date (date only) to results fields to display.
  9. Highlight the field just added and select the Summarize icon. 
  10. Select MAX(Transaction date (date only)).
  11. Under browse for fields in, click on the plus sign next to Member.  
  12. Then click on the plus sign next to Constituent on the left.
  13. In the middle, click on Name and move this to Results Fields to Display.
  14. Add any other information to results fields to display.
  15. Preview results and enter a name on the set save options tab to save and close the query.