Hello
My last question was answered, how to extract a date/time range. What I need now is to take it one step further. I need to extract the earliest time logged for any given day.
Example: 01/17/2005 0625 am
01/18/2005 0615 am
01/18/2005 0622 am
01/19/2005 0614 am
01/19/2005 0623 am
Query results I need would be:01/17/2005 0600 am
01/18/2005 0615 am
01/19/2005 0614 am
My last question was answered, how to extract a date/time range. What I need now is to take it one step further. I need to extract the earliest time logged for any given day.
Example: 01/17/2005 0625 am
01/18/2005 0615 am
01/18/2005 0622 am
01/19/2005 0614 am
01/19/2005 0623 am
Query results I need would be:01/17/2005 0600 am
01/18/2005 0615 am
01/19/2005 0614 am