If Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jose Aleman - 11 Oct 2005 23:33 GMT

Hi everyone,

I have a field named LOAN_STATUS, which is a drop down menu of the following
options. Approved & Research. I want to write the following code but I
don't know how.

IF the Refund Amount >= $350 the LOAN STATUS must equal to Research.
IF the Refund Amount <= $350 the LOAN STATUS must equal to Approved.

However, the Refund Amount is a field in the form that adds three other
fields. CREDIT_REFUND+APPRAISAL_REFUND+BROKER_REFUND=REFUND_AMOUNT

I don't have a Refund Amount field in the table.

Any input is helpful.

Reply to this Message

Sprinks - 12 Oct 2005 03:54 GMT

Hi, Jose.

Don't include a Loan Status field (or a combo box to set it) in your
table--it is fully defined by other fields in your table. Include an unbound
control to display it, and, if you need to print it on reports, or show it in
a query, include it as a calculated field in a query as well.

Set the unbound textbox' ControlSource, or the calculated query field to:

=IIf(CREDIT_REFUND+APPRAISAL_REFUND+BROKER_REFUND >=350,"Research","Approved")

Hope that helps.

Sprinks

> Hi everyone,
>
[quoted text clipped - 11 lines]
>
> Any input is helpful.

Reply to this Message