count(*)

  1. S

    Question Count(*) does not work for null values

    hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the query is : SELECT COUNT(*) AS Cntr FROM...
Top Bottom