UNION Query Parameters

[Guest]

Hi,
Im having a bit of trouble with this query, the union query works fine,
It is ok if i look at 1 product but when i try ALL it becomes too big to
process.

SELECT vw_ProductCostingTufted.Quality, vw_ProductCostingTufted.QualityCode,
vw_ProductCostingTufted.Final
FROM vw_ProductCostingTufted
WHERE (((vw_ProductCostingTufted.Final)>0));

UNION

SELECT vw_ProductCostsFB.Quality, vw_ProductCostsFB.QualityCode,
vw_ProductCostsFB.Final
FROM vw_ProductCostsFB
WHERE (((vw_ProductCostsFB.Final)>0));

UNION SELECT vw_ProductCostsFBS.Quality, vw_ProductCostsFBS.QualityCode,
vw_ProductCostsFBS.Final
FROM vw_ProductCostsFBS
WHERE (((vw_ProductCostsFBS.Final)>0));

The above query is built on top of this;

SELECT ProcessQuality.ProcessID, ProcessQuality.QualityCode,0 As FinBF, 0 As
FinBFWas, QryRawProcessSumed.SumOfRawWasteCost, ProcessQuality.Labour,
ProcessQuality.VarOverHead, ProcessQuality.FixedOverHead,
ProcessQuality.ProcessWaste, [SumOfRawWasteCost]+[TotNormCosts] AS
TotProcessCost,0 As StartTileCost, [VarOverHead]+[Labour]+[FixedOverHead] AS
TotNormCosts, "0" AS BringFor,0 As TotalStockCost,0 As Final
FROM ProcessQuality INNER JOIN QryRawProcessSumed ON
(ProcessQuality.QualityCode = QryRawProcessSumed.QualityCode) AND
(ProcessQuality.ProcessID = QryRawProcessSumed.ProcessID)
WHERE (((ProcessQuality.ProcessID)=6) AND
((ProcessQuality.QualityCode)=[Please Select Quality Code for report or Enter
ALL])) OR ((([Please Select Quality Code for report or Enter ALL])='ALL'));

UNION – This carries on for a bit & also works fine for 1 product at a time.

All i can assume is when i use the parameter ‘ALL’ it also means All
qualities and all processes? Is this true? If it is can i get round it
without having to rebuild all the queries in a different way?

Regards

CR

 

[Guest]

Sorted - it was just a school boy error