suppress report page if total = 0

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

Guest

I have a multipage report that totals a variety of fields. I would like to suppress a page from printing if the total for that page is zero. The report prints a four page document for each customer in the set. Some customers do not have any transactions that would show up on the third page and I would like to suppress it just for those customers, possible with an If then statement? Any help would be appreciated. Thank you
 
Do you expect us to know what determines what shows on page 3? Is this a
subreport? Are the records on the 3rd page unique from the records on all
other pages?

--
Duane Hookom
MS Access MVP


cathy said:
I have a multipage report that totals a variety of fields. I would like
Click to expand...
to suppress a page from printing if the total for that page is zero. The
report prints a four page document for each customer in the set. Some
customers do not have any transactions that would show up on the third page
and I would like to suppress it just for those customers, possible with an
If then statement? Any help would be appreciated. Thank you
 
Page one is the main report with pages 2-4 three subreports. The First page totals truck charges, the second material charges, the third miscellaneous charges and the forth is a summary page. All charges are pulled from the same table that is entered by individual charge tags. Each tag lists the truck, material and miscellaneous charges for that day. A query pulls out the tags for the dates needed on the report and sorts and groups them by vendor.

----- Duane Hookom wrote: ----

Do you expect us to know what determines what shows on page 3? Is this
subreport? Are the records on the 3rd page unique from the records on al
other pages

--
Duane Hooko
MS Access MV


cathy said:
I have a multipage report that totals a variety of fields. I would lik
Click to expand...
to suppress a page from printing if the total for that page is zero. Th
report prints a four page document for each customer in the set. Som
customers do not have any transactions that would show up on the third pag
and I would like to suppress it just for those customers, possible with a
If then statement? Any help would be appreciated. Thank yo
 
Create a totals query that totals the miscellaneous charges by your Vendor?
field. Add this to the record source of your main report. You can then
reference the total misc charges and cancel the printing of the subreport
and section containing the misc subreport.

--
Duane Hookom
MS Access MVP


cathy said:
Page one is the main report with pages 2-4 three subreports. The First
Click to expand...
page totals truck charges, the second material charges, the third
miscellaneous charges and the forth is a summary page. All charges are
pulled from the same table that is entered by individual charge tags. Each
tag lists the truck, material and miscellaneous charges for that day. A
query pulls out the tags for the dates needed on the report and sorts and
groups them by vendor.
 
Back
Top