I am going crazy here, I am newbie,
I am using the condition below:
not((:Heart_Rate = 60 and (Stage= 1)) and ((Heart_Rate= 100 and (Stage= 2))))
I am trying to show a text box based on a value of heart rate when person is resting(Stage=1) and Exercising (Stage=2)
However this expression shows works vice versa i.e. when
(Heart_Rate=100 and Stage=1) and (Heart_Rate=60 when stage=2)
Also
(Heart_Rate=60 and Stage=1) and (Heart_Rate=100 when stage=2)
How do I stop the second condition from happening, and tmake sure the first two conditions are first applied combined then AND the combined 2 conditions?
I hope I am making sense.