Help with automaticallly adding weekly charge

[Charles Rouse]

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

[PC Datasheet]

If you are using "Date" as the name of the date field, you need to change it to
another name. "Date' is a reserved word and sooner or later using it for a field
name will cause you trouble.

To answer your question ---
Assuming all the clients in your client table will be assessed the $2 fee, make
a query based on the client table. Make the following fields in your query:
ClientID
ChargeDate:Date ()
Charge:2

Convert this query to an append query and set to append to your financial table.
Run the query and you will assess all the clients a $2 fee for today's date.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com

"Charles Rouse" <co****@aol.com > wrote in message
news:c5******** *************** ***@posting.goo gle.com...

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

[Alan Webb]

Charles Rouse,
"INSERT INTO FINANCIAL_TBL ( CLIENT, BILL_DATE, FEE )
SELECT CLIENT_TBL.ID, Date() AS BILL_DATE, 2 AS FEE
FROM CLIENT_TBL;"
Because you can include constants, functions & such in the SQL SELECT which
gives you your list of clients that incurred fees.

"Charles Rouse" <co****@aol.com > wrote in message
news:c5******** *************** ***@posting.goo gle.com...

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