I would like to build one Calculated string based on Multiple if-then-end statements. This is not elseif. The following if is independent of the prior if statement.
If isnull([Speeding] ) = false then
"Speeding, "
End
if isNull([Distracted]) = false then
"Distracted, "
End
If IsNull([Aggressive]) = false then
"Aggressive, "
End
So, If all statements are true I would end up with String like. "Speeding, Distracted, Aggressive, "
or if middle is false I might get. "Speeding, Aggressive, "
9 answers
That middle clause will always return null
if 1+1 = 3 then " 3 Wrong, " END
That's because 1+1 will never equal 3.
