Jim DeMarco
Jdemarco at hshhp.org
Thu Jun 19 10:24:08 CDT 2003
Have you looked into the Partition() function? It puts values into buckets for you. A97 help explains it pretty well (I don't know about later versions). HTH, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] Sent: Thursday, June 19, 2003 11:09 AM To: accessd at databaseadvisors.com Subject: [AccessD] Calculating Time Cards Hi Everyone, Have a small problem that I'm hoping someone had encountered. Putting together a small application to calculate time cards. Running into some problems with the shift changes. This manufacturing firm uses a 7:00 am to 7:00 am day running three shifts. I've found several examples for calculating time cards in the knowledge base, but none seem to address the fact the "third shift" runs from 11:00 pm to 3:00 am. Of course, this means that one hour of the shift occurs on one date, and the other seven hours occur on the following date. I need to test the time input by the clerk and then based on the start and end times, determine which shift the hours fall between, then calculate time worked on each shift for each employee. Employees may clock in and out more than once during a day, and may also work overtime, as well as spread their hours between more than one shift. Most of this is already written, however, I am stumpled as to how to handle the third shift time differential? Julie Reardon-Taylor PRO-SOFT OF NY, INC. www.pro-soft.net _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************