I have a simple query where I use a right join. If an item is not found in the right joined table, it gives an error
Many values of Lamcode in the tblUncoatedFabCost are blank. In these cases I get a #Num! error in the query. How can I get 0 instead of the error as I need to use this value in a sum function?
Using Nz function on recipecostperkg did not help and I tried the IIF function as below. No help either!
I dont know VBA and use the QBE window in Design view to create queries
Many values of Lamcode in the tblUncoatedFabCost are blank. In these cases I get a #Num! error in the query. How can I get 0 instead of the error as I need to use this value in a sum function?
Using Nz function on recipecostperkg did not help and I tried the IIF function as below. No help either!
I dont know VBA and use the QBE window in Design view to create queries
SELECT tblUncoatedFabCost.FGCode, tblUncoatedFabCost.FabCode, tblUncoatedFabCost.LamCode, tblUncoatedFabCost.UncoatedFabCostPerKg AS UFKG, tblUncoatedFabCost.UncoatedFabCostPerSQM AS UFSQM, IIf([recipecostperkg] Is Null,0,[recipecostperkg]) AS RKG
FROM tblUncoatedFabCost LEFT JOIN qryCoatingRecipeHdr ON tblUncoatedFabCost.LamCode = qryCoatingRecipeHdr.CoatingCode;