I was not able to get the sql code to work, so went back to basic and all works with one exception
sql = "select escrow as VAL1 from rates where SalesPrice >= "& SalesPrice
Works great except that if the SalePrice <10000 then I get this error:
Arithmetic overflow error converting varchar to data type numeric.
All of the fields in the database are varchar (50). If the Salesprice is $10,000 or higher - NO ERROR!