Re: [AccessDevelopers] Dead Time

[Toby Bierly]

Just curious, what is the 1440 value for in the query?   Thanks, Toby ----- Original Message ----- From: A.D.Tejpal To: AccessDevelopers@yahoogroups.com Sent: Sunday, November 06, 2005 9:24 PM Subject: Re: [AccessDevelopers] Dead Time 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 Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access help Microsoft access programming Microsoft access tutorial Microsoft access 2000 tutorial Microsoft access 2003 YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.