Immediate If Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top