Results 1 to 3 of 3

Thread: Count(*) does not work for null values

Threaded View

  1. Feb 15th, 2010, 12:23 PM #1
    sifar786
    sifar786 is offline

    Thread Starter
    Member
    Join Date
    Feb 2010
    Posts
    46

    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 (Modul m LEFT OUTER JOIN
    Relation r ON m.Mod_Name = r.von)
    WHERE (m.[group] = '')
    I need a workaround for this but am unable to find one. Any help would be most appreciated.
    Last edited by sifar786; Feb 15th, 2010 at 12:27 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width