Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL query - search for null field (Access 2K SR-1)

    How do we query for null field using SQL in Access? I want to search for records with blank (unfilled) value in a certain field. I try statements like

    SELECT * FROM tblTable WHERE fldName LIKE ''
    or
    SELECT * FROM tblTable WHERE fldName LIKE ' '
    or
    SELECT * FROM tblTable WHERE fldName LIKE vbNullString
    without success.

    Can anyone help?

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL query - search for null field (Access 2K SR-1)

    SELECT * FROM tblTable WHERE fieldname IS NULL

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL query - search for null field (Access 2K SR-1)

    Thanks a lot for your help. It works. It puzzled why I couldn't find the answer in common Access books available locally.

Posting Permissions

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