Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Location
    Utah
    Posts
    136

    Unanswered: Help With Query Criteria

    I have a query that has several fields in it, one of which is a DischargeDate field. I want the query to return all records that do not contain a Discharge Date.

    What would the syntax be for something like that?

    Thanks for your time.
    Last edited by Zenaida; 12-29-05 at 14:53.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    WHERE myDateField is null

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2005
    Location
    Utah
    Posts
    136
    Thanks izyrider!

Posting Permissions

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