kbrooks
Still learning
- Local time
- Today, 16:32
- Joined
- May 15, 2001
- Messages
- 202
Is it possible to create fields in the table that are based on calculations from other fields, instead of on user input?
I have a table AccountData with several fields, including
total_charges and 3rd_party_payment
I want to create a field account_balance that would be the total of total_charges minus 3rd_party_payment. I know I could do that on the form/query/report, but I'm wondering if it's possible to do it at the table level.
I also want to create another field that is based on the above one. I would create fap_payment that would take the above created account_balance and multiply it by a field called percentage in a separate table (ApplicantData).
Is this possible? I'm running into problems with every way I've tried it. Thanks in advance!
I have a table AccountData with several fields, including
total_charges and 3rd_party_payment
I want to create a field account_balance that would be the total of total_charges minus 3rd_party_payment. I know I could do that on the form/query/report, but I'm wondering if it's possible to do it at the table level.
I also want to create another field that is based on the above one. I would create fap_payment that would take the above created account_balance and multiply it by a field called percentage in a separate table (ApplicantData).
Is this possible? I'm running into problems with every way I've tried it. Thanks in advance!