CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: counting nulls

  1. March 19th, 2001, 04:43 PM #1
    Mat Davis
    Mat Davis is offline Junior Member
    Join Date
    Jan 2001
    Posts
    6

    counting nulls


    i'm trying to count null fields in an access db -and failing.
    This is what is failing :
    If Data1.Recordset("name") = NULL Then
    num = num + 1
    If i debug it i can see that the field is null but it still tests as false.
    Any help please ?
    Thanks in advance,
    MD.


    Reply With Quote Reply With Quote
  2. March 19th, 2001, 04:46 PM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: counting nulls

    That must work
    If IsNuLL(Data1.Recordset("name")) Then
    num = num + 1


    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. March 20th, 2001, 01:10 PM #3
    Mat Davis
    Mat Davis is offline Junior Member
    Join Date
    Jan 2001
    Posts
    6

    Re: counting nulls

    that works. Thanks for the help.
    MD.

    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Featured