Sorry for the delay - I have been ill & only just got back to my computer.
Create two queries something like this:
QryTotals_1:
Code:
SELECT Table1.ArticleNumber, Nz([012012],0)+Nz([022012],0)+Nz([032012],0) AS TotalOct
FROM Table1;
QryTotals_2:
Code:
SELECT Table2.ArticleNumber, Nz([012012],0)+Nz([022012],0)+Nz([032012],0) AS TotalNov
FROM Table2;
Then create a third query using the above two as your source in Query Design View:
Join The ArticleNumber fields in the two queries [I'm assuming the Article Numbers will be the same from Oct to Nov to Dec . . .].
Drag ArticleNumber from Table1, Total Oct and TotalNov into your query.
Under TotalOct and TotalNov in the Criteria field put > 0.
Both > 0 should be on the same Criteria Row.
In SQL View, this should look something like this:
Code:
SELECT QryTotals_1.ArticleNumber, QryTotals_1.TotalOct, QryTotals_2.TotalNov
FROM QryTotals_1 INNER JOIN QryTotals_2 ON QryTotals_1.ArticleNumber = QryTotals_2.ArticleNumber
WHERE (((QryTotals_1.TotalOct)>0) AND ((QryTotals_2.TotalNov)>0));
When you run your third query, you will only see totals for those ArticlesNumbers that have Quantities > 0 in both months.
I hope this helps!!