Can I count Null values in a totals query?

[bgephart]

I have a totals query that I am trying to use to count only the Null values in a date field. So far, I'm only getting a total count regardless of what's in the field. Is this even possible? If not, can you suggest a work-around?

I'm writing this in Access 2007 but it is in 2003-compatible format.



Thanks -

[JoeM]

One way is to create a calculated field that returns a 1 if the Date field is Null, or else it returns a 0, i.e.

IIf(IsNull([MyDate]),1,0)

Then use the SUM aggregate function on this field.

[bgephart]

Thanks! That fixed it!