各位大侠,在透视表中使用如下的SQL语句 strSQL = "select 0 as [Date],999999 as [Order],Process,Category,DefectCode,0 " _ & "as Waste from [Waste+Base$] union all select Date,[Order],Process,Category,DefectCode,Waste from [Waste+$]"
'设定查询语句 strSQL = "select #1900-1-1# as [Date],999999 as [Order],Process,Category,DefectCode,0 " _ & "as Waste from [Waste+Base$] union all select Date,[Order],Process,Category,DefectCode,Waste from [Waste+$]"
'设定查询语句 strSQL = "select #1900-1-1# as [Date],999999 as [Order],Process,Category,DefectCode,0 " _ & "as Waste from [Waste+Base$] union all select Date,[Order],Process,Category,DefectCode,Waste from [Waste+$]"