IIF Statements


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
 
Ad

Advertisements

T

Tom Lake

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.

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

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

Tom Lake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top