C
Craig
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
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