Something like this (you should use parameters, though):
SELECT min(LoginDate) as minlog, max(LoginDate) as maxlog
FROM tblEmployee where UserID=1 and LoginDate BETWEEN #2014/17/07# AND #2014/18/07#;
It selects min and max login date for UserID 1 and date 17
th Jul 2014.
Quote:
can i get particular date 17th Jul 2014.min and max time?
[update]
SELECT TimeValue(min(LoginDate)) as minlog, TimeValue(max(LoginDate)) as maxlog
FROM tblEmployee where UserID=1 and LoginDate BETWEEN #2014/17/07# AND #2014/18/07#;
[/update]