Hi,
I had a table with 02 fields containing the in and out time of
employee store as DateTime data type.
1) How do I extract out the first in time and last out time , tried using the SQL MAX() and MIN() didn't work like what I want
2) add in the missing date records
like the one show below using SQL command.
Any advise or help is very much appreciated. Thank you.
example of data
in out
============== ==============
01/10/98 08:00 01/10/98 10:00
01/10/98 13:00 01/10/98 15:00
01/10/98 16:00 01/10/98 20:00
02/10/98 09:00 02/10/98 11:00
02/10/98 13:00 02/10/98 18:00
04/10/98 09:00 04/10/98 13:00
06/10/98 09:00 06/10/98 17:00
1) To be like
First in Last Out
============== ==============
01/10/98 08:00 01/10/98 20:00
02/10/98 09:00 02/10/98 18:00
And
2) Sorted Data
===========
01/10/98 08:00 01/10/98 20:00
02/10/98 09:00 02/10/98 18:00
03/10/98 00:00 03/10/98 00:00 or EMPTY but must with date
04/10/98 00:00 04/10/98 00:00 or Empty but must with date
05/10/98 00:00 05/10/98 00:00
06/10/98 09:00 06/10/98 17:00
Best Regards
Virusim