I have a query that contains
TeamId Age Period
1743 69 61-90
1743 15 14-21
1747 7 0-7
1743 19 14-21
1744 32 29-60
I have created a Union query based on the above main query, which lists the number of occurrences for each Team Id in a Period. eg: 1743 = 2 for 14-21 period. My question is, how can I ensure that the Counted figures appear in the union query in order according to the Period. ie: 0-7, 14-21, 29-60, 61-90. Thank-you for any assistance you can offer. The Union Query code I have at the moment is
Code:
SELECT Count(*) AS Period
FROM [X qryREGCOMP]
WHERE ((([X qryREGCOMP].Team_Id)=1743) AND (([X qryREGCOMP].Age_Of_Activity)<8))
UNION ALL
SELECT Count(*) AS Period
FROM [X qryREGCOMP]
WHERE ((([X qryREGCOMP].Team_Id)=1743) AND (([X qryREGCOMP].Age_Of_Activity>90)))
UNION ALL
SELECT Count(*) AS Period
FROM [X qryREGCOMP]
WHERE ((([X qryREGCOMP].Team_Id)=1743) AND (([X qryREGCOMP].Age_Of_Activity between 8 AND 15)))
UNION ALL SELECT Count(*) AS Period
FROM [X qryREGCOMP]
WHERE ((([X qryREGCOMP].Team_Id)=1743) AND (([X qryREGCOMP].Age_Of_Activity between 16 AND 22)));