Logic on "this show only"

I have an extraction request that's throwing me for a loop. The request was to the effect of, "I want to know who attended Show C two years ago and only that show - and that was their only attendance."

The only way my fevered brain is coming up with is to pull all attendees for that Show (multiple performances over several weeks), then do a pair of suppressions by date, one for everything before the start of Show C's run, and one for everything after. Is that the best way?

Thanks to all...

Parents Reply Children
No Data