Ive discovered that the path I was going down on this project is not going to work. I was hoping to be able to use these tables that are maitained on another database and it turns out thats not gonna work. I am going to try to build a new database from scratch that will hopefully do what I need and eliminate all the extra data that I don't need. Anyway, I'm gonna mark this solved and thank you all for the help. You'll probably see a similar question come up in the coming weeks from me but with different tables and date.