suppress report page if total = 0

[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

 

[Duane Hookom]

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

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

 

[Guest]

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

I have a multipage report that totals a variety of fields. I would lik

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

 

[Duane Hookom]

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

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.