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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar