Not Null In Query

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I'm sure the phrase is not Not Null, but I can't seem to find or remember
what it is?

Dim INCC As Long
INCC = Nz(DCount("PayAppliedCCRef", "tblPayApplied",
"NotNull(PayAppliedCCRef) And PayAppliedCheckID = " &
Forms!frmFXRefunds!TxtCheckID), 0)
Thanks
DS
 
DS said:
I'm sure the phrase is not Not Null, but I can't seem to find or remember
what it is?

Dim INCC As Long
INCC = Nz(DCount("PayAppliedCCRef", "tblPayApplied",
"NotNull(PayAppliedCCRef) And PayAppliedCheckID = " &
Forms!frmFXRefunds!TxtCheckID), 0)
Click to expand...


"Not IsNull(PayAppliedCCRef) And PayAppliedCheckID = " &

will work, but that uses the VBA library.

This uses only standard SQL features:

"(PayAppliedCCRef Is Not Null) And PayAppliedCheckID = " &
 
Back
Top