I have a query that has summed the Aggregate total for each round (R) for each year. I then created a crosstab query that showed which was the maximum total for each round. In the sample data it showed R1 was 99 points and Round 2 was 94 points. The actual table contains 16 rounds over 30 years.
Sample data:
R 1 54 1975
R 1 45 1975 = 99
R 1 38 1980
R 1 36 1980 = 74
R 2 25 1977
R 2 35 1977 = 60
R 2 41 1970
R 2 53 1970 = 94
Having the maximum value for each round is what I wanted, but I also need to know which year it actually occurred in. How do I get the values to have the year show alongside them? Thank you for any guidance you can offer.