I want to thank both Coffee and CirquedeSQLeil for the quick feedback.

I would not have been able to come up with either of those queries.

Great job.

thanks again,

Clay

All,

Appreciate the input so far. I have played with all the queries and it looks like I am getting very close to my end goal.

Clay