Hi,
I have a data, employee attendance record with following format
01-0002,I,4/21/2014,07:34:00
01-0002,O,4/21/2014,18:09:00
01-0002,I,4/22/2014,07:47:00
01-0002,O,4/22/2014,18:09:00
01-0002,I,4/23/2014,07:54:00
01-0002,O,4/23/2014,18:07:00
where I is in and O is out
The table contains lots of records for this saves records from the start
how can i search a record with no In or no Out from the date range specified?
I need to create a report for those employees with no In but with Out, or with In but no Out.
Another report needs to generate percentage of lates (individually or all)
For now this is the query I used but no luck
query = "Select LID, EID, Type, Dates, Time From Tlogs where EID = @e and not exists (Select Types, Dates From Tlogs t1 where t1.Type = 'I' and t1.Dates = Tlogs.Dates)"
where EID is Emp ID (01-0002), Type is In or Out (I,O), Dates (4/23/2014), Time (18:07:00)
Thanks in advance