[AccessD] Changing table values via code

Nicholson, Karen cyx5 at cdc.gov
Wed Jun 29 09:10:28 CDT 2005


Put it in a query, grouping my employeeid, totalling by hours offered
and hours taken. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, June 29, 2005 10:05 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Changing table values via code

I just need to keep a running tally of time off. An employee may call up
and say, "How much vacation time do I have?" They need to look this up
and give a quick answer. Also, yes, I will be putting these on a
report(s), as well.

>>> cyx5 at cdc.gov 6/29/2005 9:47:32 AM >>>
Is there a reason why you need to store a calculated field in a field?
Does this need to be displayed on a form?  On a report? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, June 29, 2005 9:35 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Changing table values via code

Hi everybody...long time since I've asked a question here, but I find
myself needing help again.

I am working on a db for a payroll dept. One of the things I need to do
for them is to keep a running total for time off. Basically each
employee will have a record in a table with fields for vacation,
personal, sick, etc., and I need to do two things with these numbers.
I
need to add to these totals at the beginning of each years, as they earn
more time. And, I need to subtract from these totals as they use their
time. So, when a payroll clerk enters a value of 7 hrs vacation for an
employee on a given day, I need to subtract seven from their total
vacation hours.

Both of these will be done via code, at the time of the change, but I
have never done this before. I would appreciate any direction you could
offer.

Thank you


John W Clark
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list