Thank you for the information....it was very helpful. I was able to solve my issue!

Not quite sure, I am a novice SQl user, so bare with me. I basically need to drop the time portion of the field. What are you referring to when...

Thanks to all of you for being patient and helping me out. Although I haven't had a chance to try and of your suggestions, I appreciate all the responses....stay tuned.

Karl,

I think I understand the above statement, I'm assuming where you have (<Columns&gt - that is where I would put all of the columns...

Thanks for the input,

And maybe I'm missing something here but in your response you mentioned 2 tables, where I am only working with one table with the information that I...