How to display calculated total of records with an is null date

[jjake]

I have a work order system that has a WorkOrderID as PK in tblWorkOrderNew. I have a field within tblWorkOrderNew named CompletionDate. I use a query to filter and display only the records that have an is null value in the date field. How would i display the "Amount" of is null records that are currently still open into a text box as a number.

For e.g. if i had 20 open work orders that have no completion date the box would say 20 and so on.

Thanks.

 

[Alc]

Select Count(*) from {name of query};

 

[James Deckert]

Sounds like jjake wants a sum, not a count. Use the Totals button on the ribbon and only include the value field in the query and you'll get a total.
Same as what Alc suggested, but using Sum instead of Count.
So Select Sum(field to sum) from QryShowingNullFieldRecords