Report problem - Omitting data

[Tara]

I have this report that shows all receipts from any given client. The total
outstanding balance is then tallied in the report. For some, the total
outstanding balance is $0. In this case, I don't want that person to show up
in the report. Is there a way to omit them? I know I could do it it in the
underlying query, but the only way I know to do it requires totaling
everything in the query, which would eliminate the ability to show each
receipt individually on the report.

Thanks!

 

[Duane Hookom]

Create a totals query that calculates the balance by client. Then add this
totals query to your report's record source query and join the ClientID
fields. Drop the balance field into the query grid and set its criteria to
<>0.