Sorry, missed that.
Given that you are grouping by four (4) fields, the summation
will only happen for records where all four fields match. Do you
think that could be the problem.
As an experiment, comment out the ", BonusMom, BonusTrs,
BonusTwt" from the SELECT and GROUP BY clauses and do a dump of the
query to see if it has what you want.
If it does, you may be able to leave the GROUP BY with just
PlayerName (although I would suggest grouping by the PlayerID
instead). Then you can use an aggregate function on the other
fields. For example, with most databases you can use Max() even
against a text field.
This is often a way around needing fields in the resultset
that don't need summation by aren't really part of the grouping
either.