2 Replies Latest reply on Oct 28, 2011 2:16 AM by MEh

    Problem calculating



      Problem calculating


      Hi there,

      I've set up a database where players of a team and the goals they scored are stored. On every player record all matches the team played are shown (from another db). Besides each matche I have a (repeating) field Goals where I put the number of goals the particular player scored in that particular match. Besides that I have a field called "Total amount of goals". In that field I want the total number of goals scored by that player in all matches played. This is the total of the (repeating) field Goals.

      I defined the field Total amount of goals as follows: 

      Field name: Total amount of goals
      Type: Calculation
      Options / comments: Indexed, = Count Goals

       Thing is that the number of games the particular player has scored in are counted, not the number of goals.

       Can someone point out what I am doing wrong?

      More about my db and the reason I use a repeating field here, can be found in this Insert one db into another. Help needed..