Skipping Records in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
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.
 
Got it. Thanks Duane.

Duane Hookom said:
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.
Click to expand...
 
Back
Top