Results 1 to 4 of 4

Thread: Null Values

  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Null Values

    I have a query that counts the number of records that have a certain field populated with "Y" on a per user basis. I want to have all users listed with their counts, even if their count is zero. Currently, I only get users who have a count greater than 0. Any thoughts?

    I have attached a screen shot of my query design. It's data source is the results of another query.

    I have tried various things to force all users to be lists, but no success.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Null Values

    try using NZ with the field names
    NZ[field name]

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Null Values

    I can't see your screen shot, but basically if the query is showing only the users who have a count >0, use this query (I'll call it the Count query) in a new query. In that new query place the User table and link it to your Count query with an outer join, so that you see all User table records, regardless of their existence in the Count query. Place all the fields in the grid that you additionally need to see.
    HTH
    By the way, how can I see that screen shot?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Null Values

    It isn't your browser or the Lounge, the attachment isn't there.
    Charlotte

Posting Permissions

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