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.