This has got me beat and I feel I have overlooked something obvious. I wish to paste the result of a calculation in the next available repetition in a repeating field (actually a subtraction of two paste(current time) fields) for a particular record. It was then intended to have a running total field as well which would show the total time. Any suggestion gratefully received.

Garry

I think the best way to do this would be to create a script. Use an If calculation w/in a script that says

If(repetition field > 0)

next repetition field

Else

Paste value

End IF

Then this will have to be looped so you'll end up with.

Loop

If(repetition field > 0)

Next repetition field

Else

Paste value

End IF

End Loop

Somewhere in this you need to include an exit loop line....I'm not sure where though w/o seeing your database. If you don't use and exit loop then it will loop forever and never stop.

Hope this helps.

Ryan

[email protected]

[This message has been edited by ryan93 (edited June 28, 2000).]

Thanks for the ideas. The intention is to use a script to paste "current time" into a start time field. At the end of the time interval the new current time is pasted into an end time field. A calculation field subtracts start from end giving elapsed time. The goal was to use repeating fields so a total of elapsed times could be extracted with a total of repeating field.

Hope that makes my intentions clear