I have an Access 97 database that I use to track ice hockey statistics.
I’ve created a number of reports based on this database. Right now I’m working on reports that pull player statistics from the database. Generally, there are two key criteria that play into that, which are in the Game_Info table. They are Season and Game_Type. This is because when we talk about statistics, we usually want to specify the season and the type of game (such as Regular Season vs Playoff games).
I’ve already created a form that asks for those two criteria, and from there can launch a report that gives all of the player statistics given those criteria. (For example, all player statistics for the 2000-2001 Playoffs)
My problem now is that I’m trying to create a report that will give me the entire history for a given player. This would be as follows:
———
Player name: Steve Battisti
Regular Season Games Goals Assists
1999-2000 5 10
2000-2001 10 15
Total (Obviously a calculated field)
Playoff Games Goals Assists
1999-2000 5 10
2000-2001 10 15
Total 15 25
Tournament Games Goals Assists
1999-2000 5 10
2000-2001 10 15
Total 15 25
———-
So, for each unique Player_ID, I need to report totals for goals and assists, grouped by Season and by Type (ex. 1999 regular season).
Unfortunately,I haven’t a clue how to approach this. I’m certain it has something to do with the Sorting/Grouping, but I can’t even figure out how to configure the query to base this on. I’ve also looked into crosstab queries, but I can’t seem to get the info I need. Could be sheer stupidity.
Thanks!
Steve Battisti
