Results 1 to 2 of 2
  1. 03-25-2010, 05:40 PM #1
    tipopilotas
    tipopilotas is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    5

    Query Results "Count Totals"


    I am running a query that does a count for software that installed. I was wondering how to I create the query to when the total is 0 it shows 0 vs not showing a blank field?
    Reply With Quote Reply With Quote
  2. 03-26-2010, 10:36 PM #2
    ajetrumpet
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    resarch the NZ() function. It gives you the option of providing a value in the outcome if it is naturally 0.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. update query - to replace "name" with paralell info in the next column which is Field
    By vivah in forum Queries
    Replies: 6
    Last Post: 07-25-2012, 06:42 AM
  2. "Internal OLE Automation Error" in Access 2003 query
    By littlejay in forum Queries
    Replies: 0
    Last Post: 03-04-2010, 06:32 PM
  3. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  4. Counting "true" checkboxes and ignoring "fals
    By hraup in forum Reports
    Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums