Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Cedar Rapids, IA

    Missing Counts that = 0 in query results

    I've writting a query that counts items in a list, if a particular column has nothing to count, it skips that summary in the results of the query. How do I include the zero count items as well?

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Houston, Texas USA
    How are you using the query. A Null can mean zero, but not always. Note the NZ function, e.g. NZ(ANullField)=0 and NZ(Null)=0.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running counts column
    By diane802 in forum Reports
    Replies: 1
    Last Post: 01-14-2010, 06:12 PM
  2. Replies: 1
    Last Post: 10-07-2009, 07:36 AM
  3. Weird Query results
    By UCBFireCenter in forum Queries
    Replies: 0
    Last Post: 10-06-2009, 03:38 PM
  4. Combine Query Results to One Table
    By pr4t3ek in forum Queries
    Replies: 0
    Last Post: 12-19-2008, 06:37 AM
  5. Entering query results in a form
    By marcello.dolcini in forum Forms
    Replies: 0
    Last Post: 04-15-2007, 06:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums