COMBINING TWO QUERIES

[JOE POLLOCK]

I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS
SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO
COMBINE THESE TWO SETS OF INFORMATION SO THAT I CAN SEE, SIDE BY SIDE, THE
SALES FOR EACH YEAR, SORTED BY CUSTOMER.


ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED.

REGARDS

 

[KARL DEWEY]

You can use a union query or change your query to use only one.
Year 1 Sales: Sum(IIF([Year]= 2005, [Sales], 0)
Year 2 Sales: Sum(IIF([Year]= 2006, [Sales], 0)

 

[JOE POLLOCK]

WHAT WOULD THE SQL CODE LOOK LIKE FOR A UNION QUERY?
--
JOE

You can use a union query or change your query to use only one.
Year 1 Sales: Sum(IIF([Year]= 2005, [Sales], 0)
Year 2 Sales: Sum(IIF([Year]= 2006, [Sales], 0)

--
KARL DEWEY
Build a little - Test a little

I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS
SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO
COMBINE THESE TWO SETS OF INFORMATION SO THAT I CAN SEE, SIDE BY SIDE, THE
SALES FOR EACH YEAR, SORTED BY CUSTOMER.


ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED.

REGARDS

 

[KARL DEWEY]

Like this --
SELECT Year([Date open]) AS [Sales Year], Sum([Change Requests].x) AS [Sales
QTY]
FROM [Change Requests]
GROUP BY Year([Date open])
HAVING (((Year([Date open])) = 2005 ))
UNION SELECT Year([Date open]) AS [Sales Year], Sum([Change Requests].x) AS
[Sales QTY]
FROM [Change Requests]
GROUP BY Year([Date open])
HAVING (((Year([Date open])) = 2006 ));

Or use this ---
SELECT Sum(IIf([Year]=2005,[Sales],0)) AS [Year 2005 Sales],
Sum(IIf([Year]=2006,[Sales],0)) AS [Year 2006 Sales]
FROM [Annual Sales];
--
KARL DEWEY
Build a little - Test a little

WHAT WOULD THE SQL CODE LOOK LIKE FOR A UNION QUERY?
--
JOE

You can use a union query or change your query to use only one.
Year 1 Sales: Sum(IIF([Year]= 2005, [Sales], 0)
Year 2 Sales: Sum(IIF([Year]= 2006, [Sales], 0)

--
KARL DEWEY
Build a little - Test a little

I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS
SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO
COMBINE THESE TWO SETS OF INFORMATION SO THAT I CAN SEE, SIDE BY SIDE, THE
SALES FOR EACH YEAR, SORTED BY CUSTOMER.


ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED.

REGARDS