Excluding records based on group footer value

[Paul Fenton]

I have a report that gets records from a query of customers with
balances due from various tasks.

Because of the way the client maintains his records, there will often
be a record for a customer with a balance due and then another record
for that same customer with a balance due of the same amount, but in
the NEGATIVE. Looks like this on the report:


Smith Install 11/10/03 $1,000.00
Smith Cancel 11/19/03 ($1,000.00)
Total for Smith 0.00

What I need to do in the report is exclude all of Smith's records
since the total in the Customer footer is zero.

Can I do this in the report or do I have to build a query that does
it? (Not sure how to do that either)


Paul Fenton
(e-mail address removed)

 

[Duane Hookom]

This has to be accomplished by creating a totals query and filtering out the
0 balances.