Column total at the bottom of a multipage report.

  • Thread starter Thread starter K Yero
  • Start date Start date
K

K Yero

I am using Access 2003. I have a 5-6 page sales report that prints out from a
query that I wrote. Each record's data prints out in horizontal format like
this:

Probability Qty Unit Revenue Ext Unit Revenue
25% 2 $500,000.00 $250,000.00

I figured out how to make a label, text box and a control source statement
that would give me the Ext Unit Revenue result and it prints on the report
just perfectly. What I am having a problem with is getting a single label and
text box to print once at the bottom of the 5-6 page report that would total
the Ext Unit Revenue column for the entire report.
Can anyone help? I have Access for Dummies but this makes me feel dumber
than the book can help with. :-(
 
Generally, you can use the Sum(... your expression...) in all but page
headers and footers.

Your expression might be:
=Sum([Probability] * [Qty] * [Unit Revenue])
 
Is there a way to make this appear on just the last page at the bottom of the
report, as it were?
--
K


Duane Hookom said:
Generally, you can use the Sum(... your expression...) in all but page
headers and footers.

Your expression might be:
=Sum([Probability] * [Qty] * [Unit Revenue])

--
Duane Hookom
Microsoft Access MVP


K Yero said:
I am using Access 2003. I have a 5-6 page sales report that prints out from a
query that I wrote. Each record's data prints out in horizontal format like
this:

Probability Qty Unit Revenue Ext Unit Revenue
25% 2 $500,000.00 $250,000.00

I figured out how to make a label, text box and a control source statement
that would give me the Ext Unit Revenue result and it prints on the report
just perfectly. What I am having a problem with is getting a single label and
text box to print once at the bottom of the 5-6 page report that would total
the Ext Unit Revenue column for the entire report.
Can anyone help? I have Access for Dummies but this makes me feel dumber
than the book can help with. :-(
Click to expand...
Click to expand...
 
The report Footer will appear on only the last page. If you want it in the
Page Footer of the last page, you will need to reference the control name
from the Report Footer text box in the control source of a text box in the
page footer.

You can also add some logic to identify if the current page footer is on the
last page. Perhaps a control source like:

=IIf([Page] = [Pages],[txtNameFromReportFooter], Null)

--
Duane Hookom
Microsoft Access MVP


K Yero said:
Is there a way to make this appear on just the last page at the bottom of the
report, as it were?
--
K


Duane Hookom said:
Generally, you can use the Sum(... your expression...) in all but page
headers and footers.

Your expression might be:
=Sum([Probability] * [Qty] * [Unit Revenue])

--
Duane Hookom
Microsoft Access MVP


K Yero said:
I am using Access 2003. I have a 5-6 page sales report that prints out from a
query that I wrote. Each record's data prints out in horizontal format like
this:

Probability Qty Unit Revenue Ext Unit Revenue
25% 2 $500,000.00 $250,000.00

I figured out how to make a label, text box and a control source statement
that would give me the Ext Unit Revenue result and it prints on the report
just perfectly. What I am having a problem with is getting a single label and
text box to print once at the bottom of the 5-6 page report that would total
the Ext Unit Revenue column for the entire report.
Can anyone help? I have Access for Dummies but this makes me feel dumber
than the book can help with. :-(
Click to expand...
Click to expand...
Click to expand...
 
Back
Top