G
Guest
Hi!
I think this should be fairly easy but I can't seem to wrap my brain around
it today!!
I am linked to a table that provides an EXTREMELY basic audit trail for work
tasks. Unfortunatly, for me, I cannot modify the table in any way.
The table structure and data is:
task_nbr assigned_to datetime
431526 AB7829 10/16/2007 12:52:01 PM
431526 AB7829 10/16/2007 1:12:37 PM
431526 CD4589 10/17/2007 10:17:58 AM
431526 CD4589 10/17/2007 10:18:00 AM
431938 AB2695 10/16/2007 11:39:47 AM
431938 AB2695 10/16/2007 11:39:49 AM
432206 EG0746 10/15/2007 12:39:05 PM
432206 EG0746 10/15/2007 12:40:12 PM
432206 EG0746 10/15/2007 12:50:57 PM
432206 CD1101 10/15/2007 12:50:59 PM
432254 HL1390 10/15/2007 11:30:32 AM
432254 HL1390 10/15/2007 11:55:59 AM
What I would like to create a query to extract is the first (Min) date/time
for each record where the task_nbr & assigned_to are the same.
The result from the data above:
task_nbr assigned_to datetime
431526 AB7829 10/16/2007 12:52:01 PM
431526 CD4589 10/17/2007 10:17:58 AM
431938 AB2695 10/16/2007 11:39:47 AM
432206 EG0746 10/15/2007 12:39:05 PM
432206 CD1101 10/15/2007 12:50:59 PM
432254 HL1390 10/15/2007 11:30:32 AM
Thanks in advance for any help provided!
I think this should be fairly easy but I can't seem to wrap my brain around
it today!!
I am linked to a table that provides an EXTREMELY basic audit trail for work
tasks. Unfortunatly, for me, I cannot modify the table in any way.
The table structure and data is:
task_nbr assigned_to datetime
431526 AB7829 10/16/2007 12:52:01 PM
431526 AB7829 10/16/2007 1:12:37 PM
431526 CD4589 10/17/2007 10:17:58 AM
431526 CD4589 10/17/2007 10:18:00 AM
431938 AB2695 10/16/2007 11:39:47 AM
431938 AB2695 10/16/2007 11:39:49 AM
432206 EG0746 10/15/2007 12:39:05 PM
432206 EG0746 10/15/2007 12:40:12 PM
432206 EG0746 10/15/2007 12:50:57 PM
432206 CD1101 10/15/2007 12:50:59 PM
432254 HL1390 10/15/2007 11:30:32 AM
432254 HL1390 10/15/2007 11:55:59 AM
What I would like to create a query to extract is the first (Min) date/time
for each record where the task_nbr & assigned_to are the same.
The result from the data above:
task_nbr assigned_to datetime
431526 AB7829 10/16/2007 12:52:01 PM
431526 CD4589 10/17/2007 10:17:58 AM
431938 AB2695 10/16/2007 11:39:47 AM
432206 EG0746 10/15/2007 12:39:05 PM
432206 CD1101 10/15/2007 12:50:59 PM
432254 HL1390 10/15/2007 11:30:32 AM
Thanks in advance for any help provided!