Problem: Need to transform data from horizontal to vertical. IE
Part Date Defect1 Defect2
123 5/1/2009 5 6
Part Date Defect DefectTotal
123 5/1/2009 Defect1 5
123 5/1/2009 Defect2 6
I am pretty sure this needs to be done with a sub query and I am not sure how to create it.
I have attached a snip of code. Can you tell me where to enter the subquery to Keep updated the Fields Defect and DefectTotal?
Select 'ColdSpots' As Defect,Sum(ColdSpot) as DefectTotal,
Where Dt between '5/1/2009' and '5/20/2009'