IF Command for Office 2007

[lmossolle]

Can someone assist with this


Below SAT: IF([KT Value]<100000,[KT Value],"")

 

[KARL DEWEY]

Below SAT: IIF([KT Value]<100000,[KT Value],"")

The function is IIF not IF.

 

[lmossolle]

How would you do this one?

SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")

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],"")

 

[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

How would you do this one?

SAT to 1M=IIF(AND([KT Value]>100000,{KT Value]<1000000),[KT Value],"")

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],"")

 

[lmossolle]

Access 2007

Thanks!!!!

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],"")

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],"")