Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Unanswered: Return fields which are empty within a query

    Hi,

    I am running a query where I want to return only records which contain nothing for a particular field - an id if the item has been sold. In this, I only want to find those items which are unsold.

    Can anyone help?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Someone probably can, especially if they know what your product and sales tables looked like. For the rest of us, we can't help much.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24

    null fld

    type NULL in the search criteria. you get the empty fields. (do 1 field at time tho)

Tags for this Thread

Posting Permissions

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