Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    22

    Unanswered: query that omits empty fields

    I am trying to set up a query that will only show me fields that have data in them...if field is empty then it doesnt show the field.

    is this possible?

    Please help me...

    thanks :O)

  2. #2
    Join Date
    Aug 2002
    Posts
    23

    Re: query that omits empty fields

    Use Is Not Null in the field criteria


    Originally posted by jfouse
    I am trying to set up a query that will only show me fields that have data in them...if field is empty then it doesnt show the field.

    is this possible?

    Please help me...

    thanks :O)
    A good cook doesn't use a smoke alarm for a timer.

  3. #3
    Join Date
    May 2003
    Posts
    22

    Re: query that omits empty fields

    I tried this previously and it still returns all values....


    Originally posted by RRepsher
    Use Is Not Null in the field criteria

  4. #4
    Join Date
    Aug 2002
    Posts
    23
    You might have a single space " " as the value.

    Try Is Not Null AND Not " "

    which is a single space between quotes.

    Rick
    A good cook doesn't use a smoke alarm for a timer.

Posting Permissions

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