compare values across different fields

[S Molly T]

Seems like I should know the answere to this one, but cannot figure it out.

Need to compare the value of five fields pub1 - pub5 and determine if they are the same or not. If they are ALL the same then set the value of multipub to the value contained in pub1 - pub5. If they are NOT the same, then set the value of multipub to "multipub".

I can do this with a calculation for multipub and it works except for when fields pub2 - pub5 are blank and then the calculation set the value of multipub to "multipub" because the value of pub1 is different than the value of pub2.

The attached file shows the result I am after.

Thanks for any help or pointers. :B

multipubtest.zip

[bruceR]

In general Thisitem1, thisItem2, etc. is an indicator of a design problem. But your question can easily be answered with a valuelist items calc, see attached.

multipubtest.zip

[S Molly T]

Thanks for the help.

This problem is only a small part of a larger inherited database system that is rife with such design problems, but it seems that all I have time for is to apply bandaids. Besides, don't really know where to start with a complete rebuild.