Hi Micron
really sorry about not posting the sql output
the output I get when then the ProductionOrderID is hard coded as "5" in the QryTestSheetResultsCrossTabQuery query is
Code:
?debug.Print strsqlSelect [ProductionOrderID] as Field0, [TestSheetID] as Field1, [Reel Number] as Field2, [Reel Weight] as Field3, [Tested On] as Field4, [Part Number] as Field5, [Production Number] as Field6, [Customer] as Field7, [Description] as Field8, [Material] as Field9, [Specification] as Field10, [Revision Number] as Field11, [Production Process] as Field12, [Elongation (%)] as Field13, [Lay Direction "LH or RH"] as Field14, [Lay length (mm)] as Field15, [Resistance (Ohm/m)] as Field16, null as Field17,null as Field18,null as Field19,null as Field20 From QryTestSheetResultsCrossTabQuery
and I get this when the criteria and parameters are set in the QryTestSheetResultsCrossTabQuery query to a form reference pointing to [forms]![frmtest]![text2]
Code:
Select null as Field0,null as Field1,null as Field2,null as Field3,null as Field4,null as Field5,null as Field6,null as Field7,null as Field8,null as Field9,null as Field10,null as Field11,null as Field12,null as Field13,null as Field14,null as Field15,null as Field16,null as Field17,null as Field18,null as Field19,null as Field20 From QryTestSheetResultsCrossTabQuery
steve