count duplicate fields values in a record

[Eric Number 7]

Hi I have a record with 10 fields: ie Name1,Name2,Name3....Name10.

The values of these fields can only appear no more than twice to be valid , how can I validate this and enter the result into a field ie. Names_valid ?

e.g.

Name1=fred

Name2=fred

Name3=dave

Name4=dave

Name5=charlie

Name6=charlie

Name7=harry

Name8=harry

Name9=frank

Name10=frank

is ok but:

Name1=fred

Name2=fred

Name3=fred

Name4=dave

Name5=charlie

Name6=charlie

Name7=charlie

Name8=harry

Name9=frank

Name10=frank

is not!

Can anyone help please!!!!

[-Queue-]

Create a calculation text field cNames equal to Name1 & "

[Eric Number 7]

Cheers, Ive adapted it a bit but used the logic behind it

very impressed....

Thanks...

eric

[bruceR]

Most of the time when you have fields named Something1, Something2, etc. it indicates an inappropriate design - these should be related records. What is really happening in this set of files?