@LutzM Thank you so much. I think this will get me where i need to go.
This was exactly what I was needing. I modified it to fit the full table and put some more validation on it, not your fault I forgot to include it. The query ran in 7 secs on 30,000 rows worth of data. I did take out the year portion. Your advice makes sense. We weren't sold on needing that anyway. And we can always add it in later.
This is amazing. Exactly what I was trying to do but unsure how to get there. I've got a lot more to do, but know this will help greatly. Thanks Again.