[AccessD] Calculating Time Cards

Nice solution!

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike and Doris
Manning
Sent: June 19, 2003 11:43 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Calculating Time Cards


The easiest solution would be to build a shift table that contains the start
and stop times for each shift. When the user clocks in, check the entry time
against the shift table and set a Shift field in the time clock record to
the appropriate value.