My database records
Parts of movie scenes that I want to tape (including their start and
end time)
By taking one from the other I can see how long each part of the scene
goes for
I can then add these up to the total amount of time for that scene

This works fine but then I would like to total all the time for all
scenes in that movie ( and then total the time for all movies)

Seems simple enough but whatever I am doing does not achieve this
The attached shows the report in both design view (so the control
sources can be seen) and in Preview to show the result

Can anyone see either what I have done wrong or a better way to go
about it

Thanks

Rick
(Australia)