As a legend:
Zi_Cal - the selected day
Inc_Sch - Shift start hour
ZiSc2 - the selected day +1 (day in which the shift ends)
Sf_Sch - Shift end hour
Cocea Razvan
Last Activity: Feb 19 '11, 06:47 PM
Joined: Feb 8 '11
Location:
-
Cocea Razvan replied to How to query for an interval between 18 and 6 (hours, as integer in the table)?in AccessI got it!
Thanks orangeCat for your quick reply.
Actually what I wanted to do was to select from the table the batches feeded between 19:00 hrs to 7:00 (The night shift). For the day shift it was easy, using "between 7 and 19".
Following I am posting the "winning formula", if someone ever bumps into this. It's tested and working well. I hope it makes sense, as it uses form data.
SELECT *...Leave a comment:
-
Cocea Razvan started a topic How to query for an interval between 18 and 6 (hours, as integer in the table)?in AccessHow to query for an interval between 18 and 6 (hours, as integer in the table)?
Dear all,
Probably this is a stupid question but I'm new to access.
I am trying to select from "Ora" column in the table (picture attached) values between 18 and 6. All my filtering works until here. "Ora" is defined as integer, data is inserted into the table by an external app. I cannot modify this field as the external app cannot send the date/time in a different format.
Istoric_Turnari...
No activity results to display
Leave a comment: