I have a query that is totaling Cut Lengths of a given cable reel then I use it deduct from the original received qty. The problem is if no cuts were made it omits the record completely. I need the sum of cuts to be zero if no records are found.
Any help would be greatly appreciated. I have tried NZ and a few others but given my lack of knowledge I believe the root of my problems is in the Select statement..
SQL is
SELECT DISTINCTROW [CABLE REELS].[MASTER PART ID], CUTS.[MASTER REEL ID], Sum(CUTS.[CUT LENGTH]) AS [Sum Of CUT LENGTH], [CABLE REELS].[RECIEVED QTY], [CABLE REELS].[VENDOR PART], [CABLE REELS].[RECIEVED COST CAD /FT]
FROM [CABLE REELS] INNER JOIN CUTS ON [CABLE REELS].ID = CUTS.[MASTER REEL ID]
GROUP BY [CABLE REELS].[MASTER PART ID], CUTS.[MASTER REEL ID], [CABLE REELS].[RECIEVED QTY], [CABLE REELS].[VENDOR PART], [CABLE REELS].[RECIEVED COST CAD /FT];