Statistics calculations

[Tankman]

I am creating a database to track statistics for individual players in a
hockey league. I have individual statistics by team for the first 3 seasons.
Each team has a table for each season.

How can I add data from different tables together to create cumulative stats
for each player?

 

[John W. Vinson]

I am creating a database to track statistics for individual players in a
hockey league. I have individual statistics by team for the first 3 seasons.
Each team has a table for each season.

How can I add data from different tables together to create cumulative stats
for each player?

By restructuring your database in a properly normalized fashion.

One table for season makes sense for a spreadsheet, but it's WRONG for a
relational database. Your stats table should have fields for the team *and for
the season* - an integer SeasonYear field let's say; all of the data should be
ion one single table.

With the structure you now have you will need to create a UNION query to
stitch the tables together. See UNION in the online help. You can use such a
UNION query as the basis of an append query to populate the properly
normalized table if you wish.