Code:
SELECT [RM - Raw Material Listing].Adhesive, Static.[steel-1], Static.[steel-2], Static.[steel-3], Static.[glass-1], Static.[glass-2], Static.[glass-3], Static.[poly-1], Static.[poly-2], Static.[poly-3], Static.[ldp-1], Static.[ldp-2], Static.[ldp-3], Static.[hdp-1], Static.[hdp-2], Static.[hdp-3], Static.[corr-1], Static.[corr-2], Static.[corr-3], Opacity.total_1, Opacity.total_2, Opacity.total_3, Opacity.Face_1, Opacity.Face_2, Opacity.Face_3, Opacity.Liner_1, Opacity.Liner_2, Opacity.Liner_3, Opacity.Total_avg, Opacity.Face_avg, Opacity.Liner_avg, Stiffness.Face_MD_1, Stiffness.Face_MD_2, Stiffness.Face_MD_3, Stiffness.Face_CD_1, Stiffness.Face_CD_2, Stiffness.Face_CD_3, Stiffness.Liner_MD_1, Stiffness.Liner_MD_2, Stiffness.Liner_MD_3, Stiffness.Liner_CD_1, Stiffness.Liner_CD_2, Stiffness.Liner_CD_3, Tear.[g-force-Md-1], Tear.[lb-force-Md-1], Tear.[mN-Md-1], Tear.[g-force-Md-2], Tear.[lb-force-Md-2], Tear.[mN-Md-2], Tear.[g-force-Md-3], Tear.[lb-force-Md-3], Tear.[mN-Md-3], Tear.[g-force-Cd-1], Tear.[lb-force-Cd-1], Tear.[mN-Cd-1], Tear.[g-force-Cd-2], Tear.[lb-force-Cd-2], Tear.[mN-Cd-2], Tear.[g-force-Cd-3], Tear.[lb-force-Cd-3], Tear.[mN-Cd-3], Tensile.Peak_MD_1, Tensile.Peak_MD_2, Tensile.Peak_MD_3, Tensile.Peak_MD_4, Tensile.Peak_CD_1, Tensile.Peak_CD_2, Tensile.Peak_CD_3, Tensile.Peak_CD_4, Tensile.Fail_MD_1, Tensile.Fail_MD_2, Tensile.Fail_MD_3, Tensile.Fail_MD_4, Tensile.Fail_CD_1, Tensile.Fail_CD_2, Tensile.Fail_CD_3, Tensile.Fail_CD_4, [Weights and Thickness].[Total Weight], [Weights and Thickness].[Face Weight], [Weights and Thickness].[Liner weight], [Weights and Thickness].[Adhesive Weight], [Weights and Thickness].[Total thickness 1], [Weights and Thickness].[Total Thickness 2], [Weights and Thickness].[Total Thickness 3], [Weights and Thickness].[Face Thickness 1], [Weights and Thickness].[Face Thickness 2], [Weights and Thickness].[Face Thickness 3], [Weights and Thickness].[Liner Thickness 1], [Weights and Thickness].[Liner Thickness 2], [Weights and Thickness].[Liner Thickness 3], [Weights and Thickness].[Adhesive Thickness 1], [Weights and Thickness].[Adhisive Thickness 2], [Weights and Thickness].[Adhesive Thickness 3], [Low Speed Release].[Average 1], [Low Speed Release].[Max 1], [Low Speed Release].[Min 1], [Low Speed Release].[Average 2], [Low Speed Release].[Max 2], [Low Speed Release].[Min 2], [Low Speed Release].[Average 3], [Low Speed Release].[Max 3], [Low Speed Release].[Min 3], Looptack.Steel_load_1, Looptack.Steel_mode_1, Looptack.steel_load_2, Looptack.steel_mode_2, Looptack.eel_load_3, Looptack.steel_mode_3, Looptack.glass_load_1, Looptack.glass_mode_1, Looptack.glass_load_2, Looptack.glass_mode_2, Looptack.glass_load_3, Looptack.glass_mode_3, Looptack.ploy_load_1, Looptack.poly_mode_1, Looptack.poly_Load_2, Looptack.poly_mode_2, Looptack.poly_load_3, Looptack.poly_mode_3, Looptack.ldp_load_1, Looptack.ldp_mode_1, Looptack.ldp_load_2, Looptack.ldp_mode_2, Looptack.ldp_load_3, Looptack.ldp_mode_3, Looptack.hdp_load_1, Looptack.hdp_mode_1, Looptack.hdp_load_2, Looptack.hdp_mode_2, Looptack.hdp_load_3, Looptack.hdp_load_3, Looptack.hdp_mode_3, Looptack.corr_load_1, Looptack.corr_mode_1, Looptack.corr_load_2, Looptack.corr_mode_2, Looptack.corr_load_3, Looptack.corr_mode_3, [L#].[L#]FROM (([RM - Raw Material Listing] LEFT JOIN Static ON [RM - Raw Material Listing].[Adhesive] = Static.[Adhesive]) LEFT JOIN (((((([L#] LEFT JOIN Opacity ON [L#].[L#] = Opacity.[L#]) LEFT JOIN Stiffness ON [L#].[L#] = Stiffness.[L#]) LEFT JOIN Tear ON [L#].[L#] = Tear.[L#]) LEFT JOIN Tensile ON [L#].[L#] = Tensile.[L#]) LEFT JOIN [Weights and Thickness] ON [L#].[L#] = [Weights and Thickness].[L#]) LEFT JOIN [Low Speed Release] ON [L#].[L#] = [Low Speed Release].[L#]) ON [RM - Raw Material Listing].[Part Number] = [L#].[L#]) LEFT JOIN Looptack ON [RM - Raw Material Listing].[Adhesive] = Looptack.[Adhesive]
WHERE ((([L#].[L#])=[Forms]![Search]![L1] Or ([L#].[L#])=[Forms]![Search]![L2] Or ([L#].[L#])=[Forms]![Search]![L3] Or ([L#].[L#])=[Forms]![Search]![L4] Or ([L#].[L#])=[Forms]![Search]![L5] Or ([L#].[L#])=[Forms]![Search]![L6]));