My events open and closed select all where eventcreator= Session("username") my events open select all where eventcreator= Session("username") AND eventstatus="Open" my events closed select all where eventcreator= Session("username") AND eventstatus="Closed" All events open and closed select all all events open select all where eventstatus="Open" all events closed select all where eventstatus="Closed"