ACCESS FEED: Re: [MS_AccessPros] Summarizing a query to make a new, broader query?

Rabu, 28 November 2012

Re: [MS_AccessPros] Summarizing a query to make a new, broader query?

Tony-

I suppose you could build another query on queryDifference2COPY, Group By
Style, then sum. I really didn't look at it.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Gkillah36 <GKillah36@aol.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Wednesday, November 28, 2012 8:20 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Summarizing a query to make a new, broader
query?

John,

Thank you for your response and I apologize for not mentioning what
version of Access I'm using. It is Access 2010.

But isn't everything needed already in queryDifference2COPY? Is there
really no way to summarize that query's datasheet by STYLE?

Thank you,
Tony

-----Original Message-----
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals <MS_Access_Professionals@yahoogroups.com>
Sent: Wed, Nov 28, 2012 1:58 pm
Subject: Re: [MS_AccessPros] Summarizing a query to make a new, broader
query?

Tony-

I think you would have to build new queries that focused on Style instead
of Article. For example, your "Articles" UNION query would do it on
Style, not Article. querySumUPC would have to sum by Style - but I don't
see how you would do that since there is no Style field in
tableWarehouseData.

By the way, you should always mention the version you're using. I could
see it's a .accdb file, but 2007 can't open it. Had to open it with 2010.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Tony <GKillah36@aol.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Wednesday, November 28, 2012 7:36 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Summarizing a query to make a new, broader query?

Hi everyone,

Please see my database in the Files > 2_AssistanceNeeded section. It is
named PracticeNASDatabase_112812.zip.

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

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links