Hi,
Question: How do I display totals at the end of my report?
You create a calculated control in the report footer. A calculated control
is one whose source of data is an expression rather than a field. When you
open a report that contains a calculated control, Access calculates the
correct value by using the current data. For example, to print the current
date on a report, you enter the expression =Date() in a text box. Date is a
built-in function that returns the current date as stored in your
computer's system clock. When Access runs this report, the expression in
the calculated control, Date(), is evaluated, and the current date is
displayed in the control on the report.
Understanding the report sections
Access divides the design for a report into sections. The section in which
you choose to place a calculated control determines how Access calculates
results for aggregate functions such as Sum. Here’s a summary of the
section types and their uses:
Report Header Printed once at the beginning of the report. Use the report
header for information that might normally appear on a cover page, such as
a logo or title and date. When you place a calculated control that uses the
Sum aggregate function in the report header, the sum calculated is for the
entire report. The report header prints before the page header.
Page Header Printed at the top of every page. Use a page header, for
example, to repeat the report title on every page. Aggregate functions do
not work at the page level, but you can create page-level sums by using
another technique shown later in this column.
Group Header Printed at the beginning of each new group of records. Use
the group header to print the group name. For example, in a report that is
grouped by product, use the group header to print the product name. When
you place a calculated control that uses the Sum aggregate function in the
group header, the sum is for the current group.
For Further Information :
http://office.microsoft.com/en-us/assistance/HA011224441033.aspx
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
