SELECT format( DateValue(Trans.Dt),"dd/MM/yyyy") AS DateOfAttendance, Format(Min(Trans.Dt),"Long Time") AS InTime, Format(Max(Trans.Dt),"Long Time") AS OutTime, Trans.EmpID FROM Trans WHERE (((DateValue([Trans].[Dt])) between ('4/1/2014')and('4/30/2014') and empid="0044")) GROUP BY DateValue(Trans.Dt), Trans.EmpID, Trans.CardID;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)