Duration Total

[MikeKD]

Hi Folks,

I just can't work out what I'm doing wrong here!

I've got a set list.
Each song has a duration (as a time field) in a song list table.

In the same table I have a summary field that totals the durations. This works fine, except in the one place I actually need it - the "SetListPrint" list layout.

I assume that somehow I'm sorting or finding wrong - can anyone see what I'm doing wrong? - Ideally I need total durations for each set and also for the spare songs as well as a total.

Cheers!

Mike

WKBBNoNameCopy.fmp12

[comment]

The way I understand this, you are trying to total the durations of the songs selected for a gig - so your summary field needs to be defined in the SongsForGig table, as the total of the local Duration field.

Also, since there will be only one parent record in the MusicList table, there is no need to use the Sum() function to calculate the local Duration.

[MikeKD]

Yep - once again you've hit the nail on the head!!

I was using both the other tables...

Thanks soooo much :-)