A problem with a query on access 2007?

this concern has ALSO BEEN PISSING MY FAMILY OF FOR FURTHER THAN FKING…5 hours plz guide
this is what i typed in the question:
CHOOSE Teams.ClubBadge, Clubs.TeamName, Players.Name, Players.TotalGamesPlayed(InBPL), Players.TotalGoalsScored(InBPL)
FROM Players, PTJoin, Teams
WHEREVER (((Players.PlayerID)=PID) IN ADDITION TO ((Teams.TeamID)=TID))
Collection By TotalGoalsScored(InBPL)

and i keep on getting this concern:Undefined Job “TotalGoalsScored” within expression anyone PLEASE assistance – i am just the beginner programmer and this is what i ‘m learning along at the moment

Are a person sure the following column exists if you are, try

“Group Through Players.TotalGoalsScored”.