IIF function usage issue

Giganews Newsgroups
Subject: IIF function usage issue
Posted by:  rama (chanat…@gmail.com)
Date: Fri, 9 Mar 2018

Hello,

I am using IIF function in a query as below. The purpose is to compare thre=
e conditions (1_B, 1_T & 1_S) and set value 1 is the condition is true. The=
problem is IIF function is not triggering 1 if =E2=80=9C1_S=E2=80=9D value=
is 100 or more. Kindly look into this issue and help me to resolve this is=
sue. I am using Access 2016.

FS1: IIf([1_B]=3D'0' And [1_T]=3D'1' And [1_S]>=3D'90',"1",IIf([1_B]=3D'1' =
And [1_T]=3D'2' And [1_S]<=3D'89',"1",IIf([1_T]=3D'1' And [1_B]=3D'1',"1"))=
)
Below is the results of the query

Table1 Query1
ID    1_S    1_B    1_T    FS1
1    85    0    1=09
2    95    0    1    1
3    101    0    1=09
4    85    1    2    1
5    95    1    2=09
6    110    1    2    1

Rama

Replies