Immediate If Function

N

Nancy

Can someone explain what this is? I have tried to find answers to my
questions first by reading through other people's questions. I keep seeing
this and have no idea what it is. Thanks.
 
J

jl5000

The IIF function evaluates an expression and returns a value depending on
whether the expression is true or false, for example:

=iif([Invoice_tab].[Due_Date]>Date(),"Not Due","Due")

This function evaluates the Due_Date in the invoice_tab table and if is
greater than today's date, it will return the string "Due Date", if not it
will return "Due", this function can be used in forms,queries or reports
 
N

Nancy

Many thanks!
--
nhb -- nc


jl5000 said:
The IIF function evaluates an expression and returns a value depending on
whether the expression is true or false, for example:

=iif([Invoice_tab].[Due_Date]>Date(),"Not Due","Due")

This function evaluates the Due_Date in the invoice_tab table and if is
greater than today's date, it will return the string "Due Date", if not it
will return "Due", this function can be used in forms,queries or reports

--
jl5000
<a href="http://www.joshdev.com"></a>


Nancy said:
Can someone explain what this is? I have tried to find answers to my
questions first by reading through other people's questions. I keep seeing
this and have no idea what it is. Thanks.
Click to expand...
Click to expand...
 
Top