DESIGN QUESTION

[DrewConn]

I am trying to set up a new DB that will perform an interest rate lookup function for loans. I am having a problem getting my hands around the best way to do this.

I need to be able to look up a specific interest rate based on some parameters such as loan amt, loan to value ratio, terms, etc.

Any idea's on the best way to go about this?

 

[WildHare]

Easy. Design a table that will hold your interest rate values, with other fields for the amount, LTV, etc...then use DLOOKUP or joins to return the appropriate rate.

A lot depends on the exact business rules you plan to follow. Can you codify an example such as "An amount greater than 50000 and with a LTV of less than 80% gets 5% interest, whereas an amount greater than 50000 with a LTV of greater than 80% gets 6.5%" ??

In other words, how many potential permutations can there be? I wouldn't necessarily want to populate a lookup table with a couple thosand records for this, especially if the values can change a lot. I might be easier handled in a function that does the evaluation as exampled above.

Does this help?

Jim

How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm