You got it:
SELECT PartRequest.*, [tblNovellusBOM].[Description], tblNovellusBOM_1.Description, tblNovellusBOM_2.Description, tblNovellusBOM_3.Description, tblNovellusBOM_4.Description, tblNovellusBOM_5.Description, tblNovellusBOM_6.Description, tblNovellusBOM_7.Description...