Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Evansville, Indiana, USA
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Null Query (2007)

    I have a query that has several fields. Seven of the fields represent each day of the week. The record will have data in the other fields, but I want to isolate the ones that do not have any data in all of the 7 days of the week. For example, record 1 might have data in the monday and wednesday slot, but record 2 does not have any data in any field for the week. How do i display just this record with no data?

    thanks,
    bz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Null Query (2007)

    Enter Is Null in the first Criteria line for each of the seven day columns in the query design grid.
    You can clear the Show check box for these columns if you wish, since they won't contain any data.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Evansville, Indiana, USA
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Null Query (2007)

    thanks that works.

Posting Permissions

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