Counting Null

[EllieFant]

I need to create a report counting how many people have not submitted a NAC.

This is the criteria.

The Access Type must be "PRP"
The NACSubmitted is null (This is a date field).

I need to know grouped by department how many PRP people have not submitted a NAC. I can count the fields if there is something in them, but can't seem to figure out how to count them if they are null.

How do I do this?

Thanks for any help you can provide.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[VicM]

Ellie:

In the query grid, on the criteria line for NACSubmitted, enter:

Is Null

This should give only the records whose NACSubmitted field is empty.

HTH,

Vic

 

[EllieFant]

Thanks for the help vic. I know how to get the null records, but was trying to get a count of how many were null...for example - Operations has 16 people that haven't submitted their NAC, Maintenance has 12 and etc. I figured it out though
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[CosmoKramer]

Add an invisible text box to your detail section and set its control source to:

 =IIf(IsNull([ NACSubmitted]),1,0)

Set its Running Sum property to Over Group.
Add a text box to your group footer that has the invisible text box as its control source......