I have to select the employee who have login between 9.45 am to 10

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to select the employee who have login between 9.45 am to 10.30. Time
is stored in date/time field.
 
Is the time stored by itself or do you have the date and time?

Field: TimeOnly: TimeValue(Nz(YourDateField,#00:00:00#))
Criteria: Between #09:45:00 AM# and #10:30:59 AM#

If yourdatefield has no date component then you won't need the TimeValue
function or the NZ function. If your Date field is never null, then you
won't need the NZ function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls help me 1
Duplicate records ID'ed throu criteria 4
Combining 2 tables in 1 Query Result 4
Which Wireless USB Adapter Should I Buy? 4
Query employees have null data or having Data? 1
Query to show current employees between dates 1
Date Range - Between Start and End 5
multiple criteria 4

Back
Top