How do I do column sums in an Access report?

[Guest]

I have developed an Access database to track distributions from an inventory.
I have developed a query that can extract these issues by item over a date
range; using this query I have created a report that shows this activity and
indicates the number of specific items issued over a date range.

I want Access to produce a sub-total at the bottom of each page of the
report (a columnar summation) and give a grand total on the last page. I have
read "Access manuals" and played with this until the frustration level forced
me to seek help here.

I have used "text boxes" to write statements in the footer section of the
report in design view that should have produced the running total results I
desire but the best I have done is produce a "1" on the last page of the
report and nothing on all others. I have also written statements that produce
"Error Statements" at the bottom of each page but not the result I desire.

I imagine I am missing something very simple and obvious but this problem is
giving me serious headaches (please be very simple and clear in whatever
solution you give; my old brain cannot deal with any more vagueness with
regard to this problem.; (who writes these manuals and help anyway?).

Thank you,
Marcus Zuhlke
(e-mail address removed)

 

[Marshall Barton]

I have developed an Access database to track distributions from an inventory.
I have developed a query that can extract these issues by item over a date
range; using this query I have created a report that shows this activity and
indicates the number of specific items issued over a date range.

I want Access to produce a sub-total at the bottom of each page of the
report (a columnar summation) and give a grand total on the last page. I have
read "Access manuals" and played with this until the frustration level forced
me to seek help here.

I have used "text boxes" to write statements in the footer section of the
report in design view that should have produced the running total results I
desire but the best I have done is produce a "1" on the last page of the
report and nothing on all others. I have also written statements that produce
"Error Statements" at the bottom of each page but not the result I desire.

I imagine I am missing something very simple and obvious but this problem is
giving me serious headaches (please be very simple and clear in whatever
solution you give; my old brain cannot deal with any more vagueness with
regard to this problem.; (who writes these manuals and help anyway?).

It may be simple, but what you appear to be missing is
subtle. See this How To KB article:
http://support.microsoft.com/kb/296249/en-us

Do not use the approach described in the A2000 article on
the same topic. It is seriously flawed.