IIF Statements

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

Guest

I am new to IIf statements. I am creating a field that will be called
"Income". It's value for a property would be the rate in the field "Rent" if
the field "Available" is NO, but it would be 0 if the field "Availabe" is
YES(meaning the property is not rented and therefore not generating income)
The field "Available" is created from an IFF statement based on the lease
expiration date and works - I just can't get the rate from "Rent" to transfer
to the new "Income" field. Please Help.

TIA
Bibi
 
Bibi said:
I am new to IIf statements. I am creating a field that will be called
"Income". It's value for a property would be the rate in the field "Rent"
if
the field "Available" is NO, but it would be 0 if the field "Availabe" is
YES(meaning the property is not rented and therefore not generating
income)
The field "Available" is created from an IFF statement based on the lease
expiration date and works - I just can't get the rate from "Rent" to
transfer
to the new "Income" field. Please Help.
Click to expand...

The data source of the Income control on the form should be:

=IIf([Available] = "NO", [Rent], 0)

Tom Lake
 
Back
Top