Membership in consecutive years

I’ve done this by creating a list for each year, and then using multiple “has” statements in my extraction.  Your end result will be only those constituents who are in all of the lists.

Jane Voytek

Donor Database Coordinator

Berkeley Repertory Theatre

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dan Crowell
Sent: Tuesday, May 19, 2015 2:04 PM
To: Jane Voytek
Subject: [Tessitura Development Forum] Membership in consecutive years

Hello,

I am looking to pull a report or list of all of our current members who have been a member for the past 5 (and 10) consecutive years.  When attempting to run this as an extraction, the results show all members within the date range..not just the members in all of the dates in the range.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

I’ve done this by creating a list for each year, and then using multiple “has” statements in my extraction.  Your end result will be only those constituents who are in all of the lists.

Jane Voytek

Donor Database Coordinator

Berkeley Repertory Theatre

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dan Crowell
Sent: Tuesday, May 19, 2015 2:04 PM
To: Jane Voytek
Subject: [Tessitura Development Forum] Membership in consecutive years

Hello,

I am looking to pull a report or list of all of our current members who have been a member for the past 5 (and 10) consecutive years.  When attempting to run this as an extraction, the results show all members within the date range..not just the members in all of the dates in the range.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!