Skipping Records in a Report

[Guest]

I have an Access Report (invoices) that I print and send out monthly. I
would like to suppress all of the invoices within the report that have a
balance due of 0 - not just in the printing but so that they are not part of
the report at all.

The report has a header area for the name, address, etc. and a detail area
for the items purchased. There is also a subreport which totals any payments
that they have made. In the footer I show their subtotal , payments and
balance due.

I'd appreciate any suggestions.

 

[Duane Hookom]

Apparently you have some method of calculating balance due in queries.
Create this totals query by customer/client... and add the query to your
report's record source. You can then set a criteria based on the result of
the totals query.

 

[Guest]

Duane,

I don't actually. In the footer of my report I have Subtotal, Payments and
BalanceDue. The subtotal is calculated by summing the purchases in the
detail section. The Payments are calculated by summing the payments in the
subreport. The BalanceDue is calculated by subtracting Subtotal-Payments. I
hope that explains things a little better. Any ideas?

Marcy

 

[Duane Hookom]

Create a query or queries that sum purchases and sum payments and find the
difference. Roll this up by custoerm or whatever and include the final query
in your report's record source.

 

[Guest]

Got it. Thanks Duane.

Create a query or queries that sum purchases and sum payments and find the
difference. Roll this up by custoerm or whatever and include the final query
in your report's record source.