<div>
What you have should work.<br />
<br />
<b>=Count(*)</b> should give a count of all records <br />
<br />
<b>=Count([task1])</b> should give a count of records where [task1] is not null<br />
<br />
Are you sure that you don't have records where [task1] is a zero-length string which <i>looks</i> like Null but is not?<br />
<br />
Best regards,<br />
Graham
</div>


What you have should work.

=Count(*) should give a count of all records

=Count([task1]) should give a count of records where [task1] is not null

Are you sure that you don't have records where [task1] is a zero-length string which looks like Null but is not?

Best regards,
Graham

<div>
Also try ....<br />
<br />
DCount(&quot;[task1]&quot;, &quot;YourTable/Query&quot;, &quot;Nz([task1], '')&lt;&gt;''&quot;)<br />
<br />
<br />
ET<br />
<br />
<br />

</div>


Also try ....

DCount("[task1]", "YourTable/Query", "Nz([task1], '')<>''")


ET




<div>
This will give you all the fields plus the count of all non-null values of fld3:<br />
<br />
SELECT a.fld1, a.fld3, a.fld3, (SELECT Count(b.fld3) FROM myTable b) AS CountFld3 FROM myTable a
</div>


This will give you all the fields plus the count of all non-null values of fld3:

SELECT a.fld1, a.fld3, a.fld3, (SELECT Count(b.fld3) FROM myTable b) AS CountFld3 FROM myTable a

<div>
<div class="content wysiwyg-content">
I have an Access form that I am counting the number of records in a form. If the field is null I do not want to count it but still show the record for all the other fields.<br />
<br />
This is what I am useing<br />
Count([task1])<br />
<br />
This field could be null but the other fields need to be showing. How do I count haev it count jsut the records where this field is not null
</div>
</div>


I have an Access form that I am counting the number of records in a form. If the field is null I do not want to count it but still show the record for all the other fields.

This is what I am useing
Count([task1])

This field could be null but the other fields need to be showing. How do I count haev it count jsut the records where this field is not null

Access 2033 counting number of records in a form that the field is not null

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.