Testing for null date

Results 1 to 2 of 2

Thread: Testing for null date

  1. #1
    Join Date
    Dec 1969

    Default Testing for null date

    I am javing trouble testing for a null date field with a access database. This is the query that I am using. It returns values but they are not correct.<BR><BR>SELECT * FROM Users WHERE(FirstContact &#060;&#062; null or FirstEmail &#060;&#062; null or BrochureSent &#060;&#062; null)

  2. #2
    NPKumar Guest

    Default RE: Testing for null date

    &nbsp;<BR>Pls try with this.<BR><BR>SELECT * FROM Users WHERE(FirstContact Is Not Null or FirstEmail Is NotNull or BrochureSent Is NotNull)

Posting Permissions

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