Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Unanswered: Selecting only blank (null) fields

    Let’s say I had a table like below, and I only want to select the name and any field which was blank / NULL.

    name,
    field1,
    field2,
    field3,
    field4,
    field5,
    field6,
    field7

    For example, if the name was ‘John’ and field1, 2, and 6 were blank I would want my results to be

    Name Field1 Field2 Field6
    John null null null


    Any ideas?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    'Select' where? 'Select' how? For what purpose?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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