Ahh...I spoke too soon, Michael. I had to make a minor adjustment so it worked for ALL records. I added "ELSE Company" before the END. So it now looks like:

...CASE...

Wow! You guys are fast! I knew there would be multiple ways to handle, but Michael's is surprisingly simple and works beautifully. Thanks!

Very timely post for me. I've been in management for over 10 years, but my desire to get back to the raw data level and code has increased each year....

Perfect! Worked like a charm. Thanks a million, Pam.

I've been in IT management for 5 years. Because it's a small department I wore a lot of hats, one of them database guy (Access and SQL). I miss the...