Query Totals Sum 0

[raffi]

Hello i have a query with Totals, and i have all my fields grouped up except the qty field which has the sum in it, and the qty keeps going up and down sometimes it hits 0.



is it possible to hide the grouped up record which has 0 ? i tryed something out but didn't work i created a table with Complete/Incomplete in it, and set an IIF statement in the qeury which says

IIF sum = 0 then ([Transaction Types].[Complete/Incomplete]="Complete",([Transaction Types].[Complete/Incomplete]="Incomplete"

my goal is to hide the 0 in the subform, within the mainform. and if theres anyway of hiding the record with 0 it would greatly be appreciated

Thank You.

[ranman256]

No, no iifs. In the query criteria, cant you just put Sum([field) <> 0?

[raffi]

well it worked, i feel terrible im such a noob in vba i have to learn more... but thanks i would like to thank you for the help u have provided me with, and again thanks for the help