count(*)
-
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...- sifar786
- Thread
- count(*) ms access null
- Replies: 3
- Forum: SQL Server