Is there a calculation that says "If any field equals..."

[JTSmith]

Is there a way to have a calculation that says:

If any field on this table has the value "True", then "Warning On" and if not, then "Warning Off" ?

Thanks for the help...

[Lee Smith]

You are a little vague with the details. So I'll just say, Yes?

[JTSmith]

Table is a series of Yes or No questions, along with a field called Warning. the field, Warning, is a calculation, and I want it to calculate if any of the questions are answered "Yes". If they are all no, I'm fine, so the Warning field can be left blank, but if any of them are yes, either one or all, then I would like it to change the Warning field to read WARNING.

Hope this helps.

My issue is, I want to be able to add questions easily down the road, so I'd rather not have a calculation that is something like If Question 1 = Yes or Question 2 = Yes, etc. I can live with that, but I was wondering if there was a simple calculation that was something like If ( ANY FIELD = "Yes" ; "Warning" ; "" )

[comment]

I believe your questions - or rather answers - should be individual records in a related table (or at least individual repetitions of a repeating field). Then the current problem becomes trivial - and I would venture to predict, many other issues that you may not have encountered yet.

[Teela Brown]

There is probably a more elegant way to do this, but if I understand your problem, this would work.

question (text)

answer (text) - on the layout, a yes-no radio button

yes_c (calc) - case(answer="yes", "mark")

count_yes_c (summary) - count of yes_c

warning_c (calc) - Case(count_yes_c>0; "warning")

You could also have yes and no answers in separate fields to eliminate the yes_c step.