Not Null In Query

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
 
M

Marshall Barton

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 = " &
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Operator 3
DSum Syntax 3
Line Break 9
counts NULL values in query 4
Criteria to return all records if selection from form is null 4
Using parameter in query to specify null/not null records 2
Problem with Null value elimintation criteria 2
Drop down list control value in vba 2

Top