When Null field = Null field, the results are FALSE?

[dowlingm815]

When testing the following code, the results should be true, however, a false results is generated. I don't understand why and i need to maintain the data values.

     If strTEMP_CORD_No = rstTemp!CORD_No Then
            strTEMP_BANNERPOAmt = strTEMP_BANNERPOAmt + rstTemp!BANNERPOAmt
        Else
            MsgBox "cord no not equal"
        End If

[Rabbit]

You have to use the IsNull or Nz functions if you want to compare nulls. Null fields can be anything, so they never match each other in a binary comparison. Which is what the = binary comparison operator does.

[dowlingm815]

i modified the code using the IsNull in the following matter.

     If IsNull(strTEMP_CORD_No) Then
            If IsNull(rstTemp!CORD_No) Then
                    strTEMP_BANNERPOAmt = strTEMP_BANNERPOAmt + rstTemp!BANNERPOAmt
            End If
        Else
            If strTEMP_CORD_No = rstTemp!CORD_No Then
                strTEMP_BANNERPOAmt = strTEMP_BANNERPOAmt + rstTemp!BANNERPOAmt
            End If
        End If

[Rabbit]

You could also use Nz

If Nz(Field1, "") = Nz(Field2, "") Then
   ' Do something
End If

[NeoPa]

Is this a serious question?

You are asking why the result of comparing one entirely unspecified value with another equally unspecified value doesn't return a True result when you expect it to. Good luck with that.