I'm playing around with the Time Cards in the Starter Solutions ... which uses the dreaded repeating fields

Is there a way to sum just some of the repeating values eg if there are 14 repeating values (1 for each day of a fortnight) but I only want to add up the 1st week ie values 1-7.

I've done it with this convoluted calculation

Evaluate(Left(Substitute(List(Hours_Leave);"¶";"+");Position(Substitute(List(Hours_Leave);"¶";"+");"+";1;7)-1))

but i thought there should be an easier way

..... as you might tell, this is my first play with repeating fields :-(

thanks

My advice: don't bother with repeating fields here. They have their place but this is not it.

Try some of the later starter solutions that use related tables instead of repeating fields.

Hi Vaughan, I started to play around with that but ran into a prob with putting fortnights together (there's 53 weeks in this year so it wasn't a simple matter of making a fortnight week 52 + week 1). I didn't spend a lot of time on it and went back to modifying the starter solution.

the project is still in the evaluation / development stage so I probably should persist with making related tables instead of repeating fields