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, tblNovellusBOM_8.Description, tblNovellusBOM_9.Description
FROM tblNovellusBOM AS tblNovellusBOM_9 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_8 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_7 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_6 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_5 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_4 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_3 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_2 INNER JOIN (tblNovellusBOM AS tblNovellusBOM_1 INNER JOIN (tblNovellusBOM INNER JOIN PartRequest ON [tblNovellusBOM].[PartNumber]=[PartRequest].[Part1Number]) ON tblNovellusBOM_1.PartNumber=[PartRequest].[Part2Number]) ON tblNovellusBOM_2.PartNumber=[PartRequest].[Part3Number]) ON tblNovellusBOM_3.PartNumber=[PartRequest].[Part4Number]) ON tblNovellusBOM_4.PartNumber=[PartRequest].[Part5Number]) ON tblNovellusBOM_5.PartNumber=[PartRequest].[Part6Number]) ON tblNovellusBOM_6.PartNumber=[PartRequest].[Part7Number]) ON tblNovellusBOM_7.PartNumber=[PartRequest].[Part8Number]) ON tblNovellusBOM_8.PartNumber=[PartRequest].[Part9Number]) ON tblNovellusBOM_9.PartNumber=[PartRequest].[Part10Number];
All relationships have been set and I checked that there are no AND references.
Brief explanation: Fills in the part description for the selected parts on an order form. Problem was detected when this query was used to print a Part Request (report tied to query) but only 8 of 13 would print. The 5 that would not print had blank part number fields (10 different parts weren't needed on that request).
Hope that helps.
Cj
P.S. This is the second straight query that was working but suddenly "went south"...I had to retype the last one.
