Query with Date field = Null

• bzoom100

  Ten Centuries

  Points: 1092

  More actions

  December 29, 2016 at 9:18 am

  #401291

  I have the following query, which works unless the ExpirationDate filed contains "Null". How would I make it work with Null Values? I'd like it to work where the ExpirationDate is <= or Null.

  SELECT

  tblDataPermit.ApplicationNumber

  ,tblDataPermit.PermitNumber

  ,tblDataPermit.ExpirationDate

  ,tblDataPermit.Type

  ,tblDataPermit.Status

  ,tblDataPermit.ApplicationType

  ,tblDataParcel.StreetName

  ,tblDataParcel.StreetNum

  ,tblDataParcel.Location

  FROM

  tblDataPermit

  INNER JOIN tblDataParcel

  ON tblDataPermit.ParcelID = tblDataParcel.ParcelID

  WHERE

  tblDataPermit.Type = @Type

  AND tblDataPermit.Status = @status

  AND tblDataPermit.ExpirationDate <= @ExpirationDate

• Thom A

  SSC Guru

  Points: 99126

  More actions

  December 29, 2016 at 9:22 am

  #1920023

  A simple OR Statement will suffice.

  AND (tblDataPermit.ExpirationDate <= @ExpirationDate

  OR tblDataPermit.ExpirationDate IS NULL);

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• bzoom100

  Ten Centuries

  Points: 1092

  More actions

  December 29, 2016 at 9:54 am

  #1920027

  I tried a variant of that but I did not have the () in the right places. Thank you, you're the best!