A
Alias
Hello,
I have data (days/times) that i will need to use in a query. I need to
check days of week (M-Sa) against current day of week to make sure it's a
match, if not show a message. I then need to check time of day (05:00-05:00)
against current time to make sure they match too, if not show a message.
Any help on this will be surely appreciated. I have a text field named
DaysHours in table Main with the following type of data:
All days / All hours
M-F / 6:00-6:00
M-F / 5:00-6:00
M-Sa / 8:00-5:00
M-F / 5:00-5:00
M-Sa / 6:00-6:00
(tblMain)
Main_ID
FirstName
LastName
DaysHours
StartDate
EndDate
I have data (days/times) that i will need to use in a query. I need to
check days of week (M-Sa) against current day of week to make sure it's a
match, if not show a message. I then need to check time of day (05:00-05:00)
against current time to make sure they match too, if not show a message.
Any help on this will be surely appreciated. I have a text field named
DaysHours in table Main with the following type of data:
All days / All hours
M-F / 6:00-6:00
M-F / 5:00-6:00
M-Sa / 8:00-5:00
M-F / 5:00-5:00
M-Sa / 6:00-6:00
(tblMain)
Main_ID
FirstName
LastName
DaysHours
StartDate
EndDate