Hiding detail until condition is met

cliff7376

Registered User.
Local time
Today, 20:14
Joined
Oct 10, 2001
Messages
107
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom