L
ldiaz
I have three different querys but I want all in only one
First show as follow:
Style Sum Of Qty (Rel-BAM-06) Sum Of Qty (Rel-JAXM-06)
=================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0))
AS [Sum Of Qty (Rel-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="JAXM-06",1,0)) AS [Sum Of Qty (Rel-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06"))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0)) DESC;
Second show as follow:
Style Sum Of Qty (CUT-BAM-06) Sum Of Qty (CUT-JAXM-06)
====================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0))
AS [Sum Of Qty (CUT-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="JAXM-06",1,0)) AS [Sum Of Qty (CUT-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06") AND
((IDVolatilDBID_lbl.Cut_Process_Release)=Yes))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0)) DESC;
and third shows as follow:
Style Sum Of Qty (Sub-BAM-06) Sum Of Qty (Sub-JAXM-06)
====================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="BAM-06",1,0)) AS
[Sum Of Qty (Sub-BAM-06)],
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="JAXM-06",1,0)) AS
[Sum Of Qty (Sub-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06") AND
((IDVolatilDBID_lbl.Sub_Assy_Release)=Yes))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="BAM-06",1,0)) DESC;
I would like to have one unique query like this:
Style Sum Of Qty (Rel-BAM-06) Sum Of Qty (Rel-JAXM-06) Sum Of Qty
(CUT-BAM-06) Sum Of Qty (CUT-JAXM-06) Sum Of Qty (Sub-BAM-06) Sum Of Qty
(Sub-JAXM-06)
Could you please help
First show as follow:
Style Sum Of Qty (Rel-BAM-06) Sum Of Qty (Rel-JAXM-06)
=================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0))
AS [Sum Of Qty (Rel-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="JAXM-06",1,0)) AS [Sum Of Qty (Rel-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06"))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0)) DESC;
Second show as follow:
Style Sum Of Qty (CUT-BAM-06) Sum Of Qty (CUT-JAXM-06)
====================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0))
AS [Sum Of Qty (CUT-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="JAXM-06",1,0)) AS [Sum Of Qty (CUT-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06") AND
((IDVolatilDBID_lbl.Cut_Process_Release)=Yes))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner]="BAM-06",1,0)) DESC;
and third shows as follow:
Style Sum Of Qty (Sub-BAM-06) Sum Of Qty (Sub-JAXM-06)
====================================================
SELECT IDVolatilDBID_lbl.User6 AS Style,
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="BAM-06",1,0)) AS
[Sum Of Qty (Sub-BAM-06)],
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="JAXM-06",1,0)) AS
[Sum Of Qty (Sub-JAXM-06)]
FROM To_Update_Excel_r1 INNER JOIN IDVolatilDBID_lbl ON
To_Update_Excel_r1.WO_ID = IDVolatilDBID_lbl.WO_ID
WHERE (((IDVolatilDBID_lbl.Planner)="BAM-06" Or
(IDVolatilDBID_lbl.Planner)="JAXM-06") AND
((IDVolatilDBID_lbl.Sub_Assy_Release)=Yes))
GROUP BY IDVolatilDBID_lbl.User6
ORDER BY
Sum(IDVolatilDBID_lbl.Qty*IIf(IDVolatilDBID_lbl.Planner="BAM-06",1,0)) DESC;
I would like to have one unique query like this:
Style Sum Of Qty (Rel-BAM-06) Sum Of Qty (Rel-JAXM-06) Sum Of Qty
(CUT-BAM-06) Sum Of Qty (CUT-JAXM-06) Sum Of Qty (Sub-BAM-06) Sum Of Qty
(Sub-JAXM-06)
Could you please help