MS Access - Date()-1 and Time Between 8:00am and 9:30PM
by sheilasabado - 4/14/10 3:36 AM
Hi everyone, I hope someone can help me with this problem. I have a table where I upload an SMDR file for the previous day at 12:05AM. In this table I have a field named Call Start. I would want to do a query in access which gets the Calls for yesterday's date between 8:00am and 9:30pm only. I am having a very difficult time with this.