How can I automatically add a weekly charge of $2.00 for each client
in drug treatment? I have a "financial" table linked with the client
table with 4 fields: clientID, date, charge, paid. Every week,
clients are to pay $2.00. how can I automatically add this weekly fee
for 167 clients? The form and report does the balance amount.
clientID: 1234
Date charge paid balance
02/01/04 2.00 2.00
02/03/04 2.00 .00
02/08/04 2.00 2.00
02/15/04 2.00 4.00
02/17/04 1.00 3.00
02/21/04 2.00 5.00
I need ACCESS to automatically put in the $2.00 charge each week for
all clients.
Thanks.
Charlie Rouse