Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I place <>"Refer" in the criteria of "Outcome" field of the query. Once I run the query, all null data in "Outcome" field disappeared. How can I see all data includes no null by excluding "Refer?"

    Thanks,

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    if you include - or is null - in the where claus then you should get what you want.
    eg in the Outcome column you put in the criteria - <> "Refer"
    now just put in the row below
    Is null

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Just one further point...if there are any other criteria in the query, you need to repeat them on the line where you have put 'is null' under Outcome.

    To avoid doing that you can put <> "Refer" or is null on the one line.
    Regards
    John



  4. #4
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by John Hutchison View Post
    Just one further point...if there are any other criteria in the query, you need to repeat them on the line where you have put 'is null' under Outcome.

    To avoid doing that you can put <> "Refer" or is null on the one line.
    Thanks,. This works: put <> "Refer" or is null on the one line

Posting Permissions

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