Thanks, everyone, for your assistance.

This is Monday morning, and it will take me a while to tinker with your suggestions and see if they work for me.

I completely agree that the database is a poor design; however, it's been long established at our company, and I have no power or authority to change it.

I'm a Data Analyst and not a DBA. I've got to work with what I have available.

Penny