Results 1 to 2 of 2

Thread: SQL Statement on Access

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Location
    Mexico
    Posts
    24

    Question

    Hello,
    Iam trying to select the records from an Access table where the column -> factura(string) is equal to null so I do this
    "Select * FORM ordenes WHERE factura = Null" and it doesnt work, but when I do this: <> Null it does bring the records that are not Null.

    Can you Help me?
    Thanks

  2. #2
    Guest
    change your query to
    select * from tablename where columnname is null
    this should return all rows where the columnname has a null value.

Posting Permissions

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



Click Here to Expand Forum to Full Width