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