TRANSFORM Sum(ISSUE.Qty_issue) AS [The Value] SELECT ISSUE.[Tag_no], Sum(ISSUE.Qty_issue) AS [Total Of Qty_issue] FROM ISSUE GROUP BY ISSUE.[Tag_ no] PIVOT ISSUE.Tmpe;
TRANSFORM Sum(MRV.[Ret-qty]) AS [The Value] SELECT MRV.[Tag_ no], Sum(MRV.[Ret-qty]) AS [Total Of Ret-qty] FROM MRV GROUP BY MRV.[Tag_ no] PIVOT MRV.TEMP;
TRANSFORM Sum(REC.[Rec-qty]) AS [The Value] SELECT REC.[Tag_ no], Sum(REC.[Rec-qty]) AS [Total Of Rec-qty] FROM REC GROUP BY REC.[Tag_ no] PIVOT REC.TMPE;
SELECT [Tag_no], [Val1], [Val2], [Val3] FROM ( SELECT ISSUE.[Tag_no], ISSUE.Tmpe, ISSUE.Qty_issue AS [Qty_issue] FROM ISSUE ) AS DT PIVOT ((SUM(Qty_issue) FOR Tmpe IN ([Val1], [Val2], [Val3])) AS PVT;
ISSUE.Tmpe
[Val1], [Val2], [Val3]
SELECT ISSUE.[Tag_ no], ISSUE.[Miv_ no], ISSUE.Qty_issue, ISSUE.[TT-73_no], ISSUE.Qty_issue, ISSUE.[TT-73_no], ISSUE.[Rec_ by], ISSUE.[Iso_ no], ISSUE.Double, ISSUE.Tmpe FROM ISSUE;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)