It's not really important where the data comes from. It's important how it's stored in the database. Is it one field with Date/Time format? Or 2 with text format? Or ...?
And can you tell what your difficulty is? What did you try and didn't work yet?
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.