L
lmossolle
Can someone assist with this
Below SAT: IF([KT Value]<100000,[KT Value],"")
Below SAT: IF([KT Value]<100000,[KT Value],"")
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
KARL DEWEY
Below SAT: IIF([KT Value]<100000,[KT Value],"")
The function is IIF not IF.
The function is IIF not IF.
L
lmossolle
How would you do this one?
SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")
SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")
KARL DEWEY said:Below SAT: IIF([KT Value]<100000,[KT Value],"")
The function is IIF not IF.
--
Build a little, test a little.
lmossolle said:Can someone assist with this
Below SAT: IF([KT Value]<100000,[KT Value],"")
J
John Spencer
Are you trying to do this in Excel or in Access? There is a difference
IIF([Kt Value}>100000 and [Kt Value]<1000000,[Kt Value], Null)
Don't use a zero length string "", use Null. If you use the zero-length
string Access will convert the [Kt Value] from a number type to a string type.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
IIF([Kt Value}>100000 and [Kt Value]<1000000,[Kt Value], Null)
Don't use a zero length string "", use Null. If you use the zero-length
string Access will convert the [Kt Value] from a number type to a string type.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
How would you do this one?
SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")
KARL DEWEY said:Below SAT: IIF([KT Value]<100000,[KT Value],"")
The function is IIF not IF.
--
Build a little, test a little.
lmossolle said:Can someone assist with this
Below SAT: IF([KT Value]<100000,[KT Value],"")
L
lmossolle
Access 2007
Thanks!!!!
Thanks!!!!
John Spencer said:Are you trying to do this in Excel or in Access? There is a difference
IIF([Kt Value}>100000 and [Kt Value]<1000000,[Kt Value], Null)
Don't use a zero length string "", use Null. If you use the zero-length
string Access will convert the [Kt Value] from a number type to a string type.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
How would you do this one?
SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")
KARL DEWEY said:Below SAT: IIF([KT Value]<100000,[KT Value],"")
The function is IIF not IF.
--
Build a little, test a little.
:
Can someone assist with this
Below SAT: IF([KT Value]<100000,[KT Value],"")