If Statement

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

Guest

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