SELECT [BladeData by Unit by Size Total2].UNIT AS [BladeData by Unit by Size Total2_UNIT], [BladeData by Unit by Size Total Sharpen2].SIZE AS [BladeData by Unit by Size Total Sharpen2_SIZE], [BladeData by Unit by Size Total Sharpen2].CountOfSHARPEN, [BladeData by Unit by Size Total2].SumOfSumOfCOUNT
FROM (BladeSize INNER JOIN [BladeData by Unit by Size Total Sharpen2] ON (BladeSize.Size = [BladeData by Unit by Size Total Sharpen2].SIZE) AND (BladeSize.UNIT = [BladeData by Unit by Size Total Sharpen2].UNIT)) INNER JOIN [BladeData by Unit by Size Total2] ON (BladeSize.Size = [BladeData by Unit by Size Total2].SIZE) AND (BladeSize.UNIT = [BladeData by Unit by Size Total2].UNIT);

however, I need it to produce a total even if the CountofSharpen is 0.
Can anyone help me with this?