P
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?])
for instance
=iif(text1=2,2,[?no data?])
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell
Try Null.
=IIf(text1=2,2,Null)
=IIf(text1=2,2,Null)
P
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,
also, how do you put the "more than" or "less than" functions into if
function, the expression builder is confusing me,
Ken Snell said:Try Null.
=IIf(text1=2,2,Null)
--
Ken Snell
<MS ACCESS MVP>
Pommy_g said: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?])
K
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>
=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>
Pommy_g said: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 messageTry Null.
=IIf(text1=2,2,Null)
--
Ken Snell
<MS ACCESS MVP>
Pommy_g said: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?])