SELECT [Event Number],State1 As StateX FROM qryNRStateC2 Where Not IsNull(State1)
UNION SELECT [Event Number],State2 As StateX FROM qryNRStateC2 Where Not IsNull(State2)
UNION SELECT [Event Number],State3 As StateX FROM qryNRStateC2 Where Not IsNull(State3);