2 Replies Latest reply on Oct 2, 2012 3:11 AM by lauriehughes

    Calculating records



      Calculating records


           This is probably really simple but I am only just learning....

           I am able to calculate a total for all records in my table but how do I calculate a total for records that have a common number in another field?

           by this I mean...eg

           I have a field called SCENE and another called NUMBER OF SHOTS.

           There are multiple records for each scene number and each of these records has a number in its NUMBER OF SHOTS field. How do I go about finding out the total number of shots that occur for a scene?


           Thanks in advance!!