how to replace blank with 0 in ms access [Answered]RSS

• • Reply
  bhushan_micr...

  Member

  565 Points

  396 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

• • Reply
  smirnov

  All-Star

  35159 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

  SELECT NZ(field,0) FROM table

  if value is null

  SELECT IIF(ISNULL(field), 0, field) FROM table

• • Reply
  Fei Han - MS...

  All-Star

  40485 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.

  • http://stackoverflow.com/questions/1977133/how-to-replace-blank-null-values-with-0-for-all-records

  Best Regards,

  Fei Han

  
  MSDN Community Support
  Please remember to "Mark as Answer" the responses that resolved your issue.