Last post Apr 01, 2015 01:56 AM by Fei Han - MSFT
Mar 31, 2015 08:36 AM|bhushan_microsoft|LINK
I have query in which i have fired inner join on 6 tables.and i am using sum function.the result of which is " " sometimes.so i need to replace it with 0 in ms access.so how can i do that.please suggest some way to get rid of this problem
Mar 31, 2015 08:47 AM|smirnov|LINK
if value is blank
SELECT NZ(field,0) FROM table
if value is null
SELECT IIF(ISNULL(field), 0, field) FROM table
Apr 01, 2015 01:56 AM|Fei Han - MSFT|LINK
Thanks for your post.
This similar issue discussed about how to replace blank (null ) values with 0, you could refer to it.