Results 1 to 2 of 2
  1. #1
    BudMan is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2014
    Location
    Stem, NC USA
    Posts
    20

    Question Not printing 0 value items in reports

    Microsoft® Access® for Microsoft 365 MSO (Version 2206 Build 16.0.15330.20144) 64-bit



    This question may have been asked before; however, I don’t see it.

    I have a query that summarizes numerous items and their quantity. When I print the report, it lists each item and the amount of each item. The problem is that I do not want to list an item if the quantity is either null or 0.

    Now the report would print:

    Item 1 8
    Item 2 3
    Item 3 0
    Item 4 5

    What I want is for item 3 not to be listed at all. Is there a way I can accomplish that?

    Thanks.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Of course, in the report's record source replace the original Quantity field with Nz_Quantity:Nz([Quantity],0) and add <> 0 in its criteria row.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Stretching drawn items in Reports
    By platham@copper in forum Reports
    Replies: 4
    Last Post: 02-19-2020, 09:45 AM
  2. Printing Reports through Program
    By Kundan in forum Programming
    Replies: 1
    Last Post: 07-12-2018, 02:40 AM
  3. Printing Reports & Send to PDF
    By Dnphm in forum Reports
    Replies: 4
    Last Post: 02-13-2018, 07:25 PM
  4. Printing multiple reports
    By Gater in forum Reports
    Replies: 6
    Last Post: 10-05-2014, 02:17 AM
  5. Printing Reports....
    By Danny Christie in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 05:51 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