Assigned Values

[Guest]

I am new to this and my DB has deposits in which accounts need to have a
percentage added when entered into the form. I have about 7 accounts and some
have three percent and some have two percent. For instance account
KB0013=DEPOSIT + 3%. How would i set that up in the
forms if i have seven accounts and they dont have the same discount?
Thanks

 

[Al Campagna]

jk,
I think it would be best to create a field in your account table (ex. DiscountRate)
where you can assign a discount value to each account.
Acct1 2%
Acct2 2%
Acct3 3%
Acct4 2% etc...
You would enter a deposit, and an unbound text field on the form with...
=Deposit * DiscountRate
would always display the calculated amount.
Always store the exact amount of the deposit, and just display the calculated value
using the discount rate in any subsequent form, query or report..