E endri81 Registered User. Local time , 17:19 Joined Jul 5, 2010 Messages 121 Jan 19, 2013 #1 How to get interval time of day for a query For example I have times of lessons 09:00 AM 12:00 AM 16:00 AM and want to get only times between 9-12
How to get interval time of day for a query For example I have times of lessons 09:00 AM 12:00 AM 16:00 AM and want to get only times between 9-12
jdraw Super Moderator Staff member Local time , 20:19 Joined Jan 23, 2006 Messages 15,456 Jan 19, 2013 #2 Please define 16:00 AM. You might want to describe your database, what it's for, the tables, the sort of business, and tell us in plain English about the query.
Please define 16:00 AM. You might want to describe your database, what it's for, the tables, the sort of business, and tell us in plain English about the query.
E endri81 Registered User. Local time , 17:19 Joined Jul 5, 2010 Messages 121 Jan 19, 2013 #3 Time is a field like in the picture attached. I have to extracts only times that are in interval 9-12 AM Regards Attachments 1.jpg 89.6 KB · Views: 110
Time is a field like in the picture attached. I have to extracts only times that are in interval 9-12 AM Regards
jdraw Super Moderator Staff member Local time , 20:19 Joined Jan 23, 2006 Messages 15,456 Jan 19, 2013 #4 What exactly is the query you're trying to code --tell us in plain English.
E endri81 Registered User. Local time , 17:19 Joined Jul 5, 2010 Messages 121 Jan 19, 2013 #5 I have to calculate all records from table classroom where professor has taught in the morning so before 1 P.M
I have to calculate all records from table classroom where professor has taught in the morning so before 1 P.M
jdraw Super Moderator Staff member Local time , 20:19 Joined Jan 23, 2006 Messages 15,456 Jan 19, 2013 #6 I think you are going to have to have a CourseDate as well. How do you work with professor 1 course 1 12:30 PM, and professor 1 course 2 12:20 PM records 1 and 2? What do you intend to calculate?
I think you are going to have to have a CourseDate as well. How do you work with professor 1 course 1 12:30 PM, and professor 1 course 2 12:20 PM records 1 and 2? What do you intend to calculate?
E endri81 Registered User. Local time , 17:19 Joined Jul 5, 2010 Messages 121 Jan 19, 2013 #7 Yes thank you. Attached in picture Attachments 2.jpg 91.8 KB · Views: 108
