Prev: query to trim name field?
Next: Access 2007 - Date Serial
From: khanner on 5 Mar 2010 12:37
this never used to show up till now.

'Compute Appraisal Value
If BBG("Orig# LTV").Value < 1 Then ltv = BBG("Orig# LTV").Value Else
ltv = BBG("Orig# LTV").Value / 100
loantape("OrigAppraisalValue").Value = CLng(BBG("Orig# Amt").Value)
/ CLng(ltv)
From: Jerry Whittle on 5 Mar 2010 13:41
>> If BBG("Orig# LTV").Value < 1
>> Then ltv = BBG("Orig# LTV").Value

0 < 1 is true so you need to make sure that BBG("Orig# LTV").Value isn't 0.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"khanner" wrote:

> this never used to show up till now.
>
> 'Compute Appraisal Value
> If BBG("Orig# LTV").Value < 1 Then ltv = BBG("Orig# LTV").Value Else
> ltv = BBG("Orig# LTV").Value / 100
> loantape("OrigAppraisalValue").Value = CLng(BBG("Orig# Amt").Value)
> / CLng(ltv)
 | 
Pages: 1
Prev: query to trim name field?
Next: Access 2007 - Date Serial