Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    100

    Unanswered: SELECTS that don't work

    Hello people,

    I have some problems with 2 kind of selects.
    I want to get the records which have certain field Null. Example:
    "SELECT * FROM Delivery WHERE Remark=Null"
    But the compiler says: "Too few parameters, expected 1"
    I am using OpenRecordset. With other queries work, like:
    "SELECT * FROM Delivery WHERE SupplierCode='4578'"

    I have the same problem to get records with a certain date, like:

    "SELECT * FROM Delivery WHERE ArrivalDate=6/4/2004"
    I know that there are records with this date. But the SELECT is not returning anything.

    any idea?

    Thanks in advance.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    SELECT * FROM Delivery WHERE ArrivalDate=#6/4/2004#

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    SELECT * FROM Delivery WHERE Remark IS Null

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    100

    Smile

    ey thanx hammbakka,

    Good lessons of SQL syntax!!

    :-)

Posting Permissions

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