Reply To: Running Queries based on a user inpu

[Matthias Müller]

Maybe I do not fully understand what you desire.
You can make a Flag field change by using this formula for example:
(If Number1=1,YES,NO). Instead of the NO expression you can use also nested Ifs. Just insert the same expression for the NO statement and alter the number that also should turn the Flag field to YES.

If this is not quite what you want, maybe consider using several Flag fields instead.