AnsweredAssumed Answered

Calculating records

Question asked by lauriehughes on Oct 2, 2012
Latest reply on Oct 2, 2012 by lauriehughes


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

     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!!