locked
how to replace blank with 0 in ms access RRS feed

  • Question

  • User-1569093213 posted

    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

    Tuesday, March 31, 2015 8:36 AM

Answers

  • User1508394307 posted

    if value is blank

    SELECT NZ(field,0) FROM table

    if value is null

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 31, 2015 8:47 AM

All replies