Leslie,
Thanks I think your code will work, but I am evidently leaving something out. Could you take a look and let me know if you see anything?
SELECT DISTINCT Q891666.PART_NUMBE, Q891666.DESCRIPTIO, Q891666.QTY, Q891666.OP, Q891666.WORK, Q891666.CENTER, Q891666.BASE AS [Old Base]...