Thanks for the help. I thought that a self referencing query might do the trick, but I didn't have much experience setting it up.
Thanks again. Bryan --- In AccessDevelopers@yahoogroups.com, "A.D.Tejpal" <[EMAIL PROTECTED]> wrote: > > Bryan, > > Sample query given below, should get you the dead time in minutes (lapsed between end of previous task and start of current task). > > T_Events is the name of table, Start and End are Date/Time type fields and PersonID is the field identifying the person to whom the task pertains. Field named Task is also available in the table but does not play any role in the SQL statement. > > Best wishes, > A.D.Tejpal > > Sample Query > =================================== > SELECT T_Events.*, 1440*([Start]-(Select Max(End) From T_Events As T1 Where T1.PersonID = T_Events.PersonID And T1.End <= T_Events.Start)) AS DeadTime > FROM T_Events > ORDER BY T_Events.PersonID, T_Events.Start; > =================================== > > ----- Original Message ----- > From: stomper57 > To: AccessDevelopers@yahoogroups.com > Sent: Friday, November 04, 2005 00:51 > Subject: [AccessDevelopers] Dead Time > > > Hi, > > I use a union query that tracks associates work chronologically. > I've been asked to add Dead Time between the tasks. > > Task Start End > Task1 07:00 07:30 > Task2 07:35 08:00 > > Between Task1 and Task2 there is Dead Time of 5 minutes. > > I've dumped the query results in a temp table, but how should > I capture the Dead Time? > > Thanks, > Bryan > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
