Thanks for both of your suggestions guys. They helped me out a lot. And yes I made sure to read and bookmark the article! Thx again.

Hey guys first thanks for all the replies. A calendar table was not something I considered before but I'll for sure take a look at that now. I can't really...

My apologies guys. I had to run out of town unexpectedly and I don't have all my stuff with me so I'll try and give you a basic outline of...

Thanks for the quick response and feedback. I'll give that query a try. Thanks again.

Sorry guys I should have given more details. Hopefully this post will provide better information. Ignore the table names lists above in my op. The whole point of this is...