Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find all empty fields in a query (Access 2000)

    Hi guys and gals,
    It's me again, and was wondering if you could help me tackle a question for some real nice ladies down at the local real estate office.
    What they need is a query that will bring up all records that have an empty field in them. When we try using the IsNull function it only works on the first field in the criteria grid that you typed it in, and not on any secondary fields. And we get zip for an answer. Should we put IsNull on the OR lines diagonally across for each field, or is that silly...it was a thought that just came to mind, Haven't tried it yet...any HELP would be soooooo appreciated.
    As Always, I salute all the mighty guru's in here...
    Where would I be without you...
    Nannette Padgett
    CCCC
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find all empty fields in a query (Access 2000)

    Correct. To find all records that contain an empty field, put IS Null diagonally down the criteria grid for every field of concern, i.e. each IS Null should be on a separate row (if they were on the same row yould be asking for the records that have all of their fields null).

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find all empty fields in a query (Access 2000)

    Thanks Douglas,
    You and I must have been writing at the same time.
    Appreciate the feedback however.
    Means a lot
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find all empty fields in a query (Access 2000)

    Hi guys, the brainstorm I had while writing first message seemed to work fine...will let you know if it serves their purpose when they reply.
    Typing Null for each field diaganally across the grid for each record we wished to find that had an empty field in it was the way to go. It worked...maybe this will answer someone else if they ever need to know.
    Nannette.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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