Hiding detail until condition is met

[cliff7376]

I have a report based on a query. The report shows the user multiple part numbers and then details of thier usage in the detail part of the report with a running sum text box also in the detail part of the report. I don't want any of the detail information in of the unique part number to show up until The running sum is less than or equal to zero. If i can do this in the query that would be fine as well. i just cant think of a way to group the part then the date then the qty in or out in a query.

Any ideas
thanks

 

[neileg]

Run a separate totals query, and add your less than 0 criterion to that. Bring this into your main query, and join it to your existing tables with a left join (I think). This will eliminate any items where the total is greater than zero.