Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: What is the syntax using null in SQL statment

    I need to return recordset that the sampling_data_id is null or empty.
    what is the syntax in sql statement?

    This is what I have and it is not correct
    sqlstr = "select * from tblBag_results where sampling_data_id = " & ""

    Thanks for your help!

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    sqlstr = "select * from tblBag_results where sampling_data_id Is Null"

    S-

Posting Permissions

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