The following gives you all the results with your in and out times in one query:
SELECT Format(Min(Trans.Dt),"MM/dd/yyyy HH:mm:ss") AS InOutTime, Trans.EmpID FROM Trans WHERE (Format(Trans.Dt,"Short Date") in ('8/25/2014') and Trans.InOut="0") GROUP BY Format(Trans.Dt,"Short Date"), Trans.EmpID
UNION ALL
SELECT Format(Max(Trans.Dt),"MM/dd/yyyy HH:mm:ss") AS InOutTime, Trans.EmpID FROM Trans WHERE (Format(Trans.Dt,"Short Date") in ('8/25/2014') and Trans.InOut="1") GROUP BY Format(Trans.Dt,"Short Date"), Trans.EmpID;
This one gives you the in and out time inseparate columns:
SELECT Format(Min(Trans.Dt),"MM/dd/yyyy HH:mm:ss") AS InTime,'' AS OutTime Trans.EmpID FROM Trans WHERE (Format(Trans.Dt,"Short Date") in ('8/25/2014') and Trans.InOut="0") GROUP BY Format(Trans.Dt,"Short Date"), Trans.EmpID
UNION ALL
SELECT Format(Max(Trans.Dt),'' As InTime, "MM/dd/yyyy HH:mm:ss") AS OutTime, Trans.EmpID FROM Trans WHERE (Format(Trans.Dt,"Short Date") in ('8/25/2014') and Trans.InOut="1") GROUP BY Format(Trans.Dt,"Short Date"), Trans.EmpID;