Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    15

    Unanswered: Query expression

    Hi I'm hoping someone can help me with the following problem:

    I am trying to get the syntax of a query expression right.
    The field ‘Description’ is a text field & I am trying to extract records the ‘Description’ is blank.
    I have used expressions such as:
    =””
    =” “
    LIKE “ “
    IsNull(Description)
    None of the above work. However if I use <>”” it brings back all records which contain some text in the ‘Description’ field.
    Any ideas?

    Samy5
    Edit/Delete Message

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    WHERE Nz([Description], "") = ""

    BTW, description is a reserved word, and may at some point cause you problems as a field name:

    http://support.microsoft.com/default...b;EN-US;209187
    Paul

  3. #3
    Join Date
    Jan 2008
    Posts
    15
    Thanks for that. It works.
    Samy5

Posting Permissions

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