D
dcozzi
I am trying to use an IIF statment to organize data from rows which have
specific values into 1 colum by using a query.
What is the proper syntax for 5 "ifs" and the colum i want it to return
Example
F1 f2 F3 F4 F5 F6
1 1
2 1
3 1
4 1
5 1
what would the exact syntax look like for a query to return all the 1's in a
single column of output
if FI=1 then F2
if F1=2 then F3
if F1=3 then F4
if F1=4 then F5
if F1=5 then F6
thanks
specific values into 1 colum by using a query.
What is the proper syntax for 5 "ifs" and the colum i want it to return
Example
F1 f2 F3 F4 F5 F6
1 1
2 1
3 1
4 1
5 1
what would the exact syntax look like for a query to return all the 1's in a
single column of output
if FI=1 then F2
if F1=2 then F3
if F1=3 then F4
if F1=4 then F5
if F1=5 then F6
thanks