Use values from repeating field in a text calculation?
First off, I know repeating fields are evil, but they happen to fit the application in question. What I'm curious about is whether there is a way to assemble the values found in a repeating field into a calculated text string? For example if FRUIT="apples", FRUIT="oranges" and FRUIT="bananas"... is there a way to complile them into a text string: "apples, oranges and bananas."
Also... is there a way to have it skip any blank entries so if FRUIT, FRUIT AND FRUIT are empty it will still return "apples, oranges and bananas"... or for that matter if FRUIT is empty, just "apples and banans"??
Suddenly I'm strangely hungry... anyway, any thoughts... or better ideas??