I corrected to this, and then did not get any data.?
Code:
SELECT tblAppImportFM_LM.SOWID, qryFM_IPS_LM_Price.ProductID, tblPackage.PackageColor, Sum(NZ([Imprints],0)) AS CountColor, qryFM_IPS_LM_Price.ProductPrice, Sum(NZ([Imprints],0)*[ProductPrice]) AS TotalColor, qryFM_IPS_LM_Price.PricingActive
FROM tblPackage INNER JOIN (tblAppImportFM_LM INNER JOIN qryFM_IPS_LM_Price ON tblAppImportFM_LM.SOWID = qryFM_IPS_LM_Price.SOWID) ON (tblPackage.PackageNumberID = tblAppImportFM_LM.PackageNumberID) AND (tblPackage.SOWID = tblAppImportFM_LM.SOWID)
GROUP BY tblAppImportFM_LM.SOWID, qryFM_IPS_LM_Price.ProductID, tblPackage.PackageColor, qryFM_IPS_LM_Price.ProductPrice, qryFM_IPS_LM_Price.PricingActive
HAVING (((tblPackage.PackageColor)=Yes) AND ((qryFM_IPS_LM_Price.PricingActive)=Yes));
and then amended the PackageColour to Yes to at least get something in the query.
Start of small.
Get the data row by row correct first, THEN attempt to group and Sum.?
You need to be able to see if those figures are actually correct?, si the data correct etc?