I have been asked to create the following report or list of information
· Patron Name
· Patron Address (zip code specifically)
· Total # of tickets patron purchased
· Total dollars spent by patron on ticket purchases
· Is patron a member (y/n)
for this criteria:
Seasons 2010-2011
Performance start date: 7/1/10
Performance end date: 6/30/11
Sales start date: 3/1/10
Sales end date: 6/30/11
Seasons 2011-2012
Performance start date: 7/1/11
Performance end date: 6/30/12
Sales start date: 3/1/11
Sales end date: 6/30/12
Thank you who ever can help me