comparing data

[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. 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.

.....Haps