Pls help me

P

Prashant

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

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.
 
Top