Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2015
    Posts
    22

    Unanswered: MS Access Functions with Null Values

    Hi All and Happy New Year,

    I have the below function in an MS Access query where I want to add two Expresions from this query. Unfortunately when one of the values is null, the outcome is again a null value.
    Can someone help me on how to substitute the null value with zero so as to get the correct outcome?

    (AV_FT_GL_H_HM+AV_FT_GC_A_AW)/2 AS EST_GL_H_HM,
    (AV_FT_GL_A_AW+AV_FT_GC_H_HM)/2 AS EST_GL_A_AW

    Thanks

  2. #2
    Join Date
    Oct 2015
    Posts
    22
    Hi All,

    I think problem is solved by using the NZ function, replacing Null with Zero.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •