This scripted worked beautifully, Thank you so much.

If I need this script to also sum day supply how would I go about adding that, also what would I...

Thank you so much for the information and the help I really appreciate it

I do apologize, I'm new to SQL and posting about SQL.  Usually when I'm trying to figure something out I make a table in SQLexpress with sample data to test...