davidbodhi
Davidbodhi
- Local time
- Today, 05:52
- Joined
- Jul 6, 2005
- Messages
- 79
I have a form that currently adds services and products paid for by a client, via subform calculations, indicates payment, via cash, check or charge, and shows, finally, what is still owed. This is for a clinic and some old folks, for example, pay small amounts over time.
The subtotal, sales tax, total and amount still owed are all calculated controls that are functional, but only for the current record. Each transaction record has a date/time field. Each transaction record has the patient ID.
I need to carry forward that amount owed, so that the next time that person comes in, the amount owed control reflects any amount that was owed from the last visit. Is this a case where storing that amount in a field in the 'transactions' table would be justified? Or do I need to somehow incorporate ALL the code leading up to the amount still owed, SUMing it along the way? Very ugly...
Can someone, both, give me some clear suggestions on how to do this kind of running sum on calculated controls (since SUM only works on fields) AND point me to samples of calculated amounts carried forward, if necessary?
The subtotal, sales tax, total and amount still owed are all calculated controls that are functional, but only for the current record. Each transaction record has a date/time field. Each transaction record has the patient ID.
I need to carry forward that amount owed, so that the next time that person comes in, the amount owed control reflects any amount that was owed from the last visit. Is this a case where storing that amount in a field in the 'transactions' table would be justified? Or do I need to somehow incorporate ALL the code leading up to the amount still owed, SUMing it along the way? Very ugly...
Can someone, both, give me some clear suggestions on how to do this kind of running sum on calculated controls (since SUM only works on fields) AND point me to samples of calculated amounts carried forward, if necessary?
