I have been working all afternoon to try to get my query to return a 0 when there is no results to return, I have used the NZ function as well as the IIF function but nothing is causing the query to return 0 when it is 0. Can someone help!
Code:IIF([tableStore1Info].[NumSold] IS NULL,0,[tableStore1Info].[NumSold])+IIF([tableStore2Info].[NumSold] IS NULL,0,[tableStore2Info].[NumSold]) NZ([tableStore1Info].[NumSold],0) + NZ([tableStore2Info].[NumSold],0)