I am wanting to put a Banks commission schedule inside Access.
The pricing is based off a term in years.
The terms is entered in another table : tblLetterofCredit
Example Commission Structure
Up to 3 years .6%
3-5 years .75%
Up to 4 years .6%
4-5 years .75%
I am not certain if the term parameters can be somehow written into a table or maybe it can be simplified quite easily.