By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 1,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Help with automaticallly adding weekly charge

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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******@pcdatasheet.com
www.pcdatasheet.com

"Charles Rouse" <co****@aol.com> wrote in message
news:c5**************************@posting.google.c om...
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

Nov 12 '05 #2

P: n/a
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.google.c om...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.