Results 1 to 7 of 7
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Suppress Zero in report

    I have a query that gets the below details:



    Brand Model Status
    HITACHI ZX100 Sold
    HITACHI ZX100 SOLD
    HITACHI ZX100 Stock
    HITACHI ZX100 SOLD

    Each line corresponds to a different serial number which i have not included on the report.

    On the report, I have grouped the Brand, then model as shown:

    BRAND MODEL COUNT
    HITACHI
    ZX100 1
    ZX200 0
    ZX300 0

    As you noticed, count was not in the query, what I did was insert a TEXT box and placed the following:
    =count(iif([status]="STOCK",0))

    It worked fine as shown on table 2, however, i do not want for the "0" to appear on the report.

    How can I suppress the 0.

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Do you still want the model to appear?
    If not do the grouping in the query and the count change it to a totals query. In the criteria of the count put >0
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141
    -MINTY
    I will try your suggestion and inform

    - ORANGE
    the record source is a Query

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Reports have their own sorting and grouping, so you can not rely on these in the query.
    Are you trying to eliminate records with Status = "STOCK"?

  6. #6
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141
    Quote Originally Posted by orange View Post
    Reports have their own sorting and grouping, so you can not rely on these in the query.
    Are you trying to eliminate records with Status = "STOCK"?
    -ORANGE
    I need the status="stock"

    I tried the grouping in the query, but since status is text, it is not counting the status

  7. #7
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    As you noticed, count was not in the query, what I did was insert a TEXT box and placed the following:
    =count(iif([status]="STOCK",0))

    It worked fine as shown on table 2, however, i do not want for the "0" to appear on the report.

    How can I suppress the 0.
    one way is by formatting the control on the report - something like

    0;0;"";

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

Similar Threads

  1. suppress request for a parameter
    By markjkubicki in forum Reports
    Replies: 4
    Last Post: 01-16-2018, 02:26 PM
  2. how to suppress this warning?
    By gunitinug in forum Access
    Replies: 2
    Last Post: 09-16-2017, 06:57 AM
  3. Replies: 2
    Last Post: 10-07-2016, 04:50 PM
  4. Suppress zero lines in Report
    By Fyeung in forum Reports
    Replies: 2
    Last Post: 02-18-2015, 01:07 AM
  5. Suppress Last Page
    By RayMilhon in forum Reports
    Replies: 2
    Last Post: 03-16-2012, 10:08 AM

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