pl456
Registered User.
- Local time
- Today, 10:25
- Joined
- Jan 31, 2008
- Messages
- 150
I have a field called results that I want to format to fill red. It currently checks the value of expr1 field and if greater than this value formats.
[results]>[expr1]
expr1 picks data up in the query, an iif statement, so expr1 can sometimes have a "" value.
My problem is that I also need results to compare values bewteen two other fields expr2 & expr3 and if outside this range format to fill red.
I cannot get my head around how to write this expression, beacause surely it will hit the first condition which will always be true
e.g.
results = 10, expr1 = "" 10 is greater
Is it possible to have two conditions like this?
[results]>[expr1]
expr1 picks data up in the query, an iif statement, so expr1 can sometimes have a "" value.
My problem is that I also need results to compare values bewteen two other fields expr2 & expr3 and if outside this range format to fill red.
I cannot get my head around how to write this expression, beacause surely it will hit the first condition which will always be true
e.g.
results = 10, expr1 = "" 10 is greater
Is it possible to have two conditions like this?