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