Counting Nulls With Dcount In Group Footer

[JHMarshIII]

I have read all that I can and still can't figure out what is wrong with my syntax. I am trying to count the null occurances of a field within a report. I tryed this in the group footer:

=DCount("[MemberID]","FinTreasCampRpt","[MemberID] is null")

I know I have records that meet the null test, but I get 0 when the report is run. I also have tried replacing the MemberID with an '*'. Any direction would be helpful at this point.

Thanks, John ....

 

[edtab]

I don't think you can use DCount() using report as your domain.

Consulting the Access97 Help section, you will find that second argument of this function (domain) only includes tables and queries, not reports.


edtab

 

[JHMarshIII]

Thanks for the feedback. What I ended up doing was adding an expression to the underlying query: NewMem: Nz([MemberID]),"New") to convert the nulls to a text value that could be evaluated as a control in the report. This is not the way I really wish to accomplish this, because MemberID is not always going to remain "New". But for now it is an interesting work around.