The Situation--
Previously executed retail installment sales agreements (contract) are modified, extending the term & reducing the payment amount. Previously, this data was maintained in an Excel .csv spreadsheet, but 3500 lines later, it is absurdly unwieldy when creating the modified contract via Word merge.
In Access 2003, I'm trying to building a flat file db to enter modified sales agreement contract information, prepare contracts for signature in Word (using an Access Query for merge data), and maintain a record of the customer's modfied contract parameters.
Table elements include payment amount (currency) and loan interest (percent), in addition to things like name, loan term, payment dates, etc. [Loan parameters are not part of this db function as they are calculated elsewhere in financial systems software.]
My Problem:
I need users to enter the interest amount on the form as it is conventionaly viewed: 4.78% -- 10.39% -- 13.83%.
The only way I've been able to capture percent to the table is to enter: .0478 -- .1039 -- 0.1383.
I've struggled with this, experimenting with the Table field properties:
Data Type: Number
Field Size: Single
Format: Percent
Decimal Places: 2
Do I need to adjust something in the Percent control on the form? Or do I need to fix something in the table?
help appreciated