Jim Dettman
jimdettman at earthlink.net
Wed Jun 29 09:44:10 CDT 2005
I'd second that. Definitely keep a record of hours earned and hours used. When someone doesn't like the answer they get on what's left, your going to need that detail<g>. Now although it's considered a no-no, you may want keep a summary field in a record and update that every time you write a record into the above table. The approach I like to use though is to always generate a balance by totaling the records, but include the ability to store a "balance forward" record when a purge is done. The balance forward record is a summary of the purged detail. This allows a client to purge the table when performance issues start to creep in, but still maintain a sound relational design. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Nicholson, Karen Sent: Wednesday, June 29, 2005 10:10 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Changing table values via code 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com