IIF Statements

[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

 

[Tom Lake]

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.

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

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

Tom Lake