var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Filtering records by time range and weekends days
I am a novice user in MS Access. I have table with following fields:
My Date and time formats are "22-07-02" and "11:54:20 AM", respectively.
Now I want to filter above data by pulling records where "Time_of_call" in range of 12:01:00 AM (mid-night) to 06:59:00 AM, and "Date_of_call" is weekends only.
Sounds very difficult for me but I am sure there are clever guys in this Forum who might help me.
Thanks for your time and valuable advise.
if you defined your Date_of_call and Time_of_call fields as anything other than date/time data types, you will have great difficulty in getting what you want
for the filter, you can use
where hour(datetimefield) between 0 and 6
for the weekend test, you can use
where weekday(datetimefield) in (1,7)
but these will work only if you used a proper datetime field (combining Date_of_call and Time_of_call, probably)
see Microsoft Access Misc. Tips