Convert three querys in one only

G

Guest

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
 
P

pietlinden

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
Click to expand...

how about a union query? or OR your criteria together.
 
G

Guest

i tried UNION but it shows datas in consecutive (Y) rows

I want
Style Sum Of Qty (CUT-BAM-06) Sum Of Qty (CUT-JAXM-06) and so in X
--
Lorenzo Díaz
Cad Technician


[email protected] said:
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
Click to expand...

how about a union query? or OR your criteria together.
Click to expand...
 
B

Bob Quintal

I have three different querys but I want all in only one
Click to expand...


What you want to do is firstly get your results in a vertical query
that returns

STYLE TYPE Planner [Sum of Quantity]
1 REL BAM-06 12
1 REL JAXM-06 3
1 CUT BAM-06 4
1 CUT JAXM-06 3
1 SUB BAM-06 4
1 SUB JAXM-06 3
2 REL BAM-06 12
2 REL JAXM-06 32
2 CUT BAM-06 4
2 CUT JAXM-06 3
2 SUB BAM-06 4
2 SUB JAXM-06 3

then convert that to your end result using a crosstab query.




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] ="BA
M-06",1,0)) AS [Sum Of Qty (Rel-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner] ="JA
XM-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] ="BA
M-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] ="BA
M-06",1,0)) AS [Sum Of Qty (CUT-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner] ="JA
XM-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] ="BA
M-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
Click to expand...
 
G

Guest

No, I want result as follow:


Style | A | B | C | D | E | F |
CONC 5 2 2 1 2 1
TOC 5 2 2 1 2 1

A=Sum Of Qty (Rel-BAM-06)
B=Sum Of Qty (Rel-JAXM-06)
C=Sum Of Qty (CUT-BAM-06)
D=Sum Of Qty (CUT-JAXM-06)
E=Sum Of Qty (Sub-BAM-06)
F=Sum Of Qty (Sub-JAXM-06)

Style field is [User6]
BAM-06 or JAXM-07 is in [Planner] field


--
Lorenzo Díaz
Cad Technician


Bob Quintal said:
I have three different querys but I want all in only one
Click to expand...


What you want to do is firstly get your results in a vertical query
that returns

STYLE TYPE Planner [Sum of Quantity]
1 REL BAM-06 12
1 REL JAXM-06 3
1 CUT BAM-06 4
1 CUT JAXM-06 3
1 SUB BAM-06 4
1 SUB JAXM-06 3
2 REL BAM-06 12
2 REL JAXM-06 32
2 CUT BAM-06 4
2 CUT JAXM-06 3
2 SUB BAM-06 4
2 SUB JAXM-06 3

then convert that to your end result using a crosstab query.




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] ="BA
M-06",1,0)) AS [Sum Of Qty (Rel-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner] ="JA
XM-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] ="BA
M-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] ="BA
M-06",1,0)) AS [Sum Of Qty (CUT-BAM-06)],
Sum([IDVolatilDBID_lbl].[Qty]*IIf([IDVolatilDBID_lbl].[Planner] ="JA
XM-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] ="BA
M-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
Click to expand...
Click to expand...
 
B

Bob Quintal

No, I want result as follow:


Style | A | B | C | D | E | F |
CONC 5 2 2 1 2 1
TOC 5 2 2 1 2 1

A=Sum Of Qty (Rel-BAM-06)
B=Sum Of Qty (Rel-JAXM-06)
C=Sum Of Qty (CUT-BAM-06)
D=Sum Of Qty (CUT-JAXM-06)
E=Sum Of Qty (Sub-BAM-06)
F=Sum Of Qty (Sub-JAXM-06)

Style field is [User6]
BAM-06 or JAXM-07 is in [Planner] field
Click to expand...
you still want to use a crosstab query.
Get your sum query to give this first.

STYLE TYPE PLANNER QTY
CONC REL BAM-06 12
CONC REL JAXM-06 3
CONC CUT BAM-06 4
CONC CUT JAXM-06 3
CONC SUB BAM-06 4
CONC SUB JAXM-06 3
TOC REL BAM-06 12
TOC REL JAXM-06 32
TOC CUT BAM-06 4
TOC CUT JAXM-06 3
TOC SUB BAM-06 4
TOC SUB JAXM-06 3


this SQL should do that.

SELECT A.User6 AS Style,
"REL" AS TYPE,
A.PLANNER,
sum(A.QTY) as QTY
FROM FROM To_Update_Excel_r1 ALIAS B
INNER JOIN IDVolatilDBID_lbl ALIAS A
ON B.WO_ID = A.WO_ID
GROUP BY A.User6,"REL",A.PLANNER
UNION
SELECT A.User6 AS Style,
switch(IDVolatilDBID_lbl.Cut_Process_Release),"CUT",
IDVolatilDBID_lbl.Sub_Assy_Release,SUB) AS TYPE,
A.PLANNER,
sum(A.QTY) as QTY
FROM FROM To_Update_Excel_r1 ALIAS B
INNER JOIN IDVolatilDBID_lbl ALIAS A
ON B.WO_ID = A.WO_ID
GROUP BY A.User6,"REL",A.PLANNER


Then you concatenate to create the header.
HH: "Sum Of Qty (" & TYPE & "-" & PLANNER & ")"

STYLE TYPE PLANNER QTY HH
CONC REL BAM-06 12 Sum Of Qty (REL-BAM-06)
CONC REL JAXM-06 3 Sum Of Qty (REL-JAXM-06)
CONC CUT BAM-06 4 Sum Of Qty (CUT-BAM-06)
CONC CUT JAXM-06 3 Sum Of Qty (CUT-JAXM-06)
CONC SUB BAM-06 4 Sum Of Qty (SUB-BAM-06)
CONC SUB JAXM-06 3 Sum Of Qty (SUB-JAXM-06)
TOC REL BAM-06 12 Sum Of Qty (REL-BAM-06)
TOC REL JAXM-06 32 Sum Of Qty (REL-JAXM-06)
TOC CUT BAM-06 4 Sum Of Qty (CUT-BAM-06)
TOC CUT JAXM-06 3 Sum Of Qty (CUT-JAXM-06)
TOC SUB BAM-06 4 Sum Of Qty (SUB-BAM-06)
TOC SUB JAXM-06 3 Sum Of Qty (SUB-JAXM-06)

Then you cross tab.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Value in Third and quarter column, how fix ? 4
two columns in Query (BAM-06, JAXM-06) 4
Help in Query with two condition 4
two queries from same data in table into one query 2
Error - CANNOT HAVE AGGREGATE FUNCTION IN EXPRESSION 4
Get data for only last three months 1
The Microsoft Jet database engine does not recognize... 5
How do I query a temp table in Access 3

Top