Search results for query: *

Nevermind, figured it out on my own,I used Between DateAdd("n",450,[Start Date]) And DateAdd("n",480,[End Date]). But your expression helped me change to that line of thinking so thanks!

PHV, The DateAdd version you gave works great, I needed to adjust it for 30 minute increments (such as 7:00AM to 7:30AM)where the same expression works great, but i am having difficulty adjusting it for a time increment such as 7:30-8:00AM. Can you help me with that?

Thanks! Sorry I thought I replied to this already, I just came back to refer to it once more and I realized I never said thank you!

I have a criteria written as >=DateAdd("h",7,[Start Date]) And <=DateAdd("h",19,[End Date]) this works great but I now need to do one from 7AM-7:15PM. How can I change my criteria to state that?

Man I'm an idiot, I just realized what you are talking about. Guess I can understand that phrase "can't see the forest for the trees". Ok, I get the table bucket now. I will play with it tomorrow. Going back to something you said earlier, what did you mean by "You should not be using parameter...

Ok, I will be honest, I really don't understand the whole idea of creating table buckets. I would be more than happy to learn. I don't want to take up all your time but can either of you maybe direct me to something that would walk me through it? I appreciate your help. Thanks!

Thanks everyone, that is a lot of great information. FYI, I am using Access 2007. Ok, Duane, quick question, if I go down your path, how can i create a table with the information when it is pulling from a linked ODBC? I can't modify the information being pulled in. Tyrone, I have to play...

Thanks for the advice! Can you give me an example of what you mean by "format your call time so that it falls in a specific range"?

I will do my best here to explain myself, this is my first post in this forum so be sure to tell me if I am not following procedure. I have a query that pulls data from an ODBC link. It pulls all calls in according to the date I enter (parameter: >=DateAdd("h",7,[Start Date])And<=("h",19,[End...