I have a query with a list of games won and lost. I am trying to sum the wins and losses to show the total of games played.
Using the expressionI get a message about needing the ID but I have not had any success in doing so.Code:GmsPlayed: Sum([W16]+[L16])
The query is called 'NFLStandingsQry' and the team ID would be 'NFLID' all data is from the source table 'NFLTeamsT'.
I am not sure how to properly include the ID in the formula.
Thanks
Jim O