Thanks for the response. Funny thing you mention Cobol, as our system is still based on it. (not that i know it more than the semester i took in school...
Awesome! It worked! Apparently I overcomplicated it. Sorry, never used SQL until this project. (occasional ms access use) Jack of all trades, master of few.. =)