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
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
566 Points
398 Posts
how to replace blank with 0 in ms access
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
thanking you
All-Star
35149 Points
9075 Posts
Re: how to replace blank with 0 in ms access
Mar 31, 2015 08:47 AM|smirnov|LINK
if value is blank
if value is null
All-Star
40565 Points
6233 Posts
Microsoft
Re: how to replace blank with 0 in ms access
Apr 01, 2015 01:56 AM|Fei Han - MSFT|LINK
Hi bhushan,
Thanks for your post.
This similar issue discussed about how to replace blank (null ) values with 0, you could refer to it.
Best Regards,
Fei Han