Hi I have a hockey pool database and I want to be able to add each weeks totals (goals, assists, etc.) for the players on each team.
Example: Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals and 2 assists for week one, I want to be able to get the total of 12. Team two has three different players and they may score 3 goal and three assists for a total of 18. Then team 3, 4, 5, etc. I have three tables, one with the teams (I call it manager) and one for the players (called roster). I have a reference table that links the manger and roster tables together to determine what players are on what teams. Any help is appreciated. CR