karmaimages
Registered User.
- Local time
- Today, 08:59
- Joined
- Nov 19, 2009
- Messages
- 15
Hi,
I've created a database to keep track of repayments from customers, which I've attached to the post for easier viewing. I'm not sure if I can post images yet which isn't helpful trying to explain this.
From the form I have a running total of what is left to pay using the stating amount - amount paid - previous final figure which works great
What I'd like to do is update the remaining balance figure at the top of the form from the running total but keep that value stored in the database table for reporting purposes and to be able to export it at a later date.
Any idea how I could go about this? Is it easy? I'm quite the beginner at Access but trying to learn as i go along.
Many thanks in advance
I've created a database to keep track of repayments from customers, which I've attached to the post for easier viewing. I'm not sure if I can post images yet which isn't helpful trying to explain this.
From the form I have a running total of what is left to pay using the stating amount - amount paid - previous final figure which works great
What I'd like to do is update the remaining balance figure at the top of the form from the running total but keep that value stored in the database table for reporting purposes and to be able to export it at a later date.
Any idea how I could go about this? Is it easy? I'm quite the beginner at Access but trying to learn as i go along.
Many thanks in advance