IIf string question

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a query and in one of the fields I want to have a
new column (Answer) appear that displays 1 if the
answer1_1 (in the same query) contains the value of true
otherwise I want the Answer column to display 0.

Using a null value expression example I started to build
the following but it didn't work. This string is in the
field portion of the query:

Answer: IIf(true([answer1_1]),1,0)

What should it be to return the values I want?
 
Self -

Image: IIf([answer1_1]="True","1","0")

I figured it out as soon as I posted it! :) Brent

If you have another way let me know.
 
Hi Brent,

There is nothing wrong with your method, but
another method might be

Image: Abs([answer1_1])

Brent said:
Self -

Image: IIf([answer1_1]="True","1","0")

I figured it out as soon as I posted it! :) Brent

If you have another way let me know.
-----Original Message-----
I have a query and in one of the fields I want to have a
new column (Answer) appear that displays 1 if the
answer1_1 (in the same query) contains the value of true
otherwise I want the Answer column to display 0.

Using a null value expression example I started to build
the following but it didn't work. This string is in the
field portion of the query:

Answer: IIf(true([answer1_1]),1,0)

What should it be to return the values I want?
.
Click to expand...
Click to expand...
 
Back
Top