calculations on only SOME of the repeating field values

[Cateleb]

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

[Vaughan]

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.

[Cateleb]

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