5 Replies Latest reply on Dec 2, 2008 10:20 AM by brianism

    Best Way to calculate totals from query

    brianism Level 1
      Could someone point me in the right direction to add up my data and distinctly show it in my query?

      I have a table with the following fields:
      id, team_id, compname, teamname, totallost

      I want to add up the "totallost" row where the "team_id" and "compname" fields are the same...then show the compname with the sum of the totallost once in my table and determine who is winning.