Recent content by divaD

Thanks for your response, just.a.guy. I will begin work on your suggestions today. It may take a couple of days, but I'll let you know how it goes. Thanks again.

I have a self join query that pulls a bill of material 7 levels deep. Here is the SQL: SELECT tblItemMaster.PartNmbr, tblItemMaster.ItemClass, "1" AS [Level 1], tblBOM.ChildClass, tblBOM.ChildPartNmbr, tblBOM.QtyReq, "2" AS [Level 2], tblBOM_2.ChildClass, tblBOM_2.ChildPartNmbr, tblBOM_2.QtyReq...