SELECT qry_Operation_20_good.BASE_ID
,qry_Operation_20_good.PART_ID
,qry_Operation_20_good.OPERATION_SEQ_NO
,Sum([SumOfGOOD_QTY] - [QTY40]) AS Waiting_For_Glass
FROM qry_Operation_20_good
INNER JOIN qry_Operation_40_total ON qry_Operation_20_good.BASE_ID = qry_Operation_40_total.BASE_ID
GROUP BY qry_Operation_20_good.BASE_ID
,qry_Operation_20_good.PART_ID
,qry_Operation_20_good.OPERATION_SEQ_NO
HAVING (((Sum([SumOfGOOD_QTY] - [QTY40])) > 100));