Results 1 to 4 of 4

Thread: easy questionnn

  1. #1
    Join Date
    Jul 2003
    Posts
    292

    Unanswered: easy questionnn

    I fergot how to count all null field in a query...

    First I'm tryin to get all "Y" in a yes no field ... so in my query I add my table then add my field .. i put the letter Y in the criteria.. and it pulls all "Y" yes for that field...

    Next I add in my date field.. which pulls all dates with "Y" in it..
    some of those fields are blank..

    I want to run a count of how many fields are blank in my date field...

    I want to return a number of how many are blank..

    I know you do a count of IsNULL in the criteria.. but i fergot how.. could someone enlighten me??

    thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Try this

    SELECT Count(yourTable.yourField) AS [Count of empty Fields]
    FROM FGD
    HAVING (((Count(yourTable.yourField)) Is Not Null));


  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Sorry for douplcation:

    Try this

    SELECT Count(yourTable.yourField) AS [Count of empty Fields]
    FROM yourTable
    HAVING (((Count(yourTable.yourField)) Is Not Null));

  4. #4
    Join Date
    Jul 2003
    Posts
    292
    thanks It worked !

Posting Permissions

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