repeating field comparison

[Haps93]

Is there any way to compare the data in a repeating field between 2 records and have the differences reported ? for example, i am designing a manufacturing schedule for a printing company that incorporates up to 10 different colours (repeating field) whenever changing from one job to the next , some,none or all of these colours may change and may or may not appear in the same repetition. I would like to capture the differences ie: 3 same & 7 different. I would then be able to incorporate these numbers into costs and ultimately show scheduling efficiency.

[batgirl003]

See my post following yours. I THINK I have the same situation as you let me know if this helps you.

[Vaughan]

I suspect that related records would have been more efficient than repeating fields: you can sort and loop through related records much easier to perform the comparison.