IIF Function

[Pommy_g]

Hi, i have a iif function and what value do i need to enter to make no data come up?



for instance

=iif(text1=2,2,[?no data?])

 

[Ken Snell]

Try Null.

=IIf(text1=2,2,Null)

 

[Pommy_g]

yeh it was null thanks

also, how do you put the "more than" or "less than" functions into if
function, the expression builder is confusing me,

Try Null.

=IIf(text1=2,2,Null)
--
Ken Snell
<MS ACCESS MVP>

Hi, i have a iif function and what value do i need to enter to make no data come up?



for instance

=iif(text1=2,2,[?no data?])

 

[Ken Snell]

=IIf(text1>2,2,Null)
=IIf(text1<2,2,Null)
=IIf(text1>=2,2,Null)
=IIf(text1<=2,2,Null)

I don't use the Expression builder...I just type the symbols into the code.

--
Ken Snell
<MS ACCESS MVP>

yeh it was null thanks

also, how do you put the "more than" or "less than" functions into if
function, the expression builder is confusing me,

"Ken Snell" <[email protected]> wrote in message

Try Null.

=IIf(text1=2,2,Null)
--
Ken Snell
<MS ACCESS MVP>

Hi, i have a iif function and what value do i need to enter to make no data come up?



for instance

=iif(text1=2,2,[?no data?])