Count NULL records

[davidmcolaco]

Hi,

I have a form where I display some stats from what zone in country are the customers from, but I want to count the records where I don't have information too, that are empty.
How can I do that? I was trying this code, but it doesn't work.

ClientesRS.Open "SELECT * From Clientes WHERE c_distrito=''", m_oConn
txtSemDistrito.Text = ClientesRS.RecordCount

Thanks in advance.

 

[gmmastros]

NULLs are not the same as empty strings. Luckily, you can convert nulls to empty strings for comparisons.

Also, you don't need to return a full recordset, you can use the database to perform a count.

Select Count(*) As Count
From Clientes
Where IsNull(c_distrito, '') = ''

Then
txtSemDistrito.Text = RS("Count")



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Jasen]

And you don't even need to replace the nulls if you aren't doing anything with them anyway. You could also just make the where clause:

Where c_distrito IS NULL