Valore null

[sergran]

Hello, I have a query


SELECT Count (Lista_cd.Recensione) AS ConteggioDiRecensione Lista_cd FROM HAVING (((Count (Lista_cd.Recensione)) Is Not Null));


the result is 238 when in fact many records are empty.
What is wrong?
thanks
Hello

[pbaldy]

They may contain a zero length string ("") rather than Null.

[sergran]

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[pbaldy]

Happy to help!