G Guest Sep 25, 2006 #1 I have to select the employee who have login between 9.45 am to 10.30. Time is stored in date/time field.
I have to select the employee who have login between 9.45 am to 10.30. Time is stored in date/time field.
D Duane Hookom Sep 25, 2006 #2 Create a query with this SQL view: SELECT e.*, l.* FROM tblEmployees e JOIN tblLogins l on e.EmployeeID = l.EmployeeID WHERE l.LoginTime Between #9:45:00# AND #10:30:00#; If this wag doesn't meet your needs, come back with enough information about your tables and fields so we don't have the guess.
Create a query with this SQL view: SELECT e.*, l.* FROM tblEmployees e JOIN tblLogins l on e.EmployeeID = l.EmployeeID WHERE l.LoginTime Between #9:45:00# AND #10:30:00#; If this wag doesn't meet your needs, come back with enough information about your tables and fields so we don't have the guess.
