Summarizing a query to make a new, broader query?

[TKTheKid]

Hi everyone,

Please see my attached database.

queryDifference2COPY compares tables tableKWIData and tableWarehouseData and spits out the differences between their quantities by ARTICLE. It also maintains columns from each table regardless of whether or not there is a corresponding ARTICLE in both tables. For example, ARTICLE 1111111111 is only found in tableWarehouseData, but those records still appear in the query as "Differences" even though there is no ARTICLE to compare to in tableKWIData.

So, the bottom line is, since I already have this query in place, is there any way to just summarize queryDifference2COPY and create a new, separate query based off of it that does the same thing, but by STYLE instead of ARTICLE? COLOR and SIZE and ARTICLE would not feature in the new query at all actually. It should just compare the quantities from each table summarized by STYLE only.



I hope this makes sense!

Thanks for any help!

Tony

[TKTheKid]

Anyone?

Thank you!

[June7]

Why copy of query?

Is this what you want:

SELECT Sum(queryDifference2.[KWI QUANTITY]) AS [SumOfKWI QUANTITY], Sum(queryDifference2.[WHSE QUANTITY]) AS [SumOfWHSE QUANTITY], queryDifference2.STYLE
FROM queryDifference2
GROUP BY queryDifference2.STYLE;

[TKTheKid]

Ah, yes. Thanks again June!