how to count no data in a database

[MaxEd]

I have a data table setup but I want to see if there are any empty cells in the datatable. I used a


Dcount("myField","mytable","myfield isempty&quot

Am I using this correctly?

 

[gol4]

Dcount("myFieldindex","mytable","isnull([myfield])&quot

will produce results need to count a field that would not be empty

Dcount("myField","mytable","isnull([myfield])&quot

produces 0

Dcount("myFieldindex","mytable","isnull([myfield])&quot

produce accurate count

 

[MaxEd]

gol4, Thanks for the tip!! That worked great! I have done some coding over the past few months but I'm still new to some of the little details of MsAccess 2000.