count records ignoring those with null values

  • Thread starter Thread starter annette
  • Start date Start date
A

annette

I would like to count records in particular fields
ignoring those with null values. Help please!!!
 
Ignoring nulls is the default for counting:
=DCount("MyField", "MyTable")
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
Grouping and Counting null records 2
counting Null fields 3
help with counting records in sub form 1
Counting Null Values 3
Looking for dedup/ignore nulls suggestion 4
Continuous Form - Populate unbounded field 1
how do I count "is null" return "pending" in access 11

Back
Top