I have a table that shows the scores (Australian Rules Football) of a whole lot of games played over the Seasons. An example of that data is:
R Age Year Team G1 B1 P1 Team V G2 B2 P2
1 15 1980 Beaconsfield 10 10 70 Berwick 25 12 162
2 15 1990 Beaconsfield 11 11 77 Noble 17 17 119
3 15 2000 Beaconsfield 6 6 42 Narre 18 19 127
The reason I have shown the same Team in the left 'Team' column is the basis for my question. I run a crosstab query which shows me the Maximum 'P2' kicked against each Team (in this case Beaconsfield). What do I need to do next to get the next query to show the Maximum result along with the corresponding details such as 'Team V', 'G2' and 'B2'. My original crosstab query shows me the Year, Age and Maximum P2. Any guidance would be greatly appreciated.
R Age Year Team G1 B1 P1 Team V G2 B2 P2
1 15 1980 Beaconsfield 10 10 70 Berwick 25 12 162
2 15 1990 Beaconsfield 11 11 77 Noble 17 17 119
3 15 2000 Beaconsfield 6 6 42 Narre 18 19 127
The reason I have shown the same Team in the left 'Team' column is the basis for my question. I run a crosstab query which shows me the Maximum 'P2' kicked against each Team (in this case Beaconsfield). What do I need to do next to get the next query to show the Maximum result along with the corresponding details such as 'Team V', 'G2' and 'B2'. My original crosstab query shows me the Year, Age and Maximum P2. Any guidance would be greatly appreciated.
