Report Totals

[ThomP]

good morning all,

I have a report, with a total of 100 in the detail section. 25 of A, 25 of
B, 25 of C, and 25 of D. These will change as time goes on.

How can I create a running total for A,B,C and D?

Thank you in Advance

 

[Marshall Barton]

good morning all,

I have a report, with a total of 100 in the detail section. 25 of A, 25 of
B, 25 of C, and 25 of D. These will change as time goes on.

How can I create a running total for A,B,C and D?

Try using a text box with its RunningSum property set to
Over All or Over Group depending on what else your report is
doing.

If that doesn't doo what you want, then post back with more
details about your report and how you want this running
total calculated.

 

[ThomP]

I have a report for a Doctors office, on this report is (for example) 25
head, 25 neck, 25 throat. will increase as time goes on. I would like to,
on my report have a running total of these.

I can get the report to total all of them. by using
= count ([Organ site]), in the report footer but cannot get them individually.

I am thinking I may have to go the way of a "make table query" and report
off of that.

Thanks

thanks

 

[Duane Hookom]

If you simply want to totals of each in the report footer, then create a
totals query similar to your report's record source and use it in a subreport
--
Duane Hookom
Microsoft Access MVP

I have a report for a Doctors office, on this report is (for example) 25
head, 25 neck, 25 throat. will increase as time goes on. I would like to,
on my report have a running total of these.

I can get the report to total all of them. by using
= count ([Organ site]), in the report footer but cannot get them individually.

I am thinking I may have to go the way of a "make table query" and report
off of that.

Thanks

thanks
--
thomp

Try using a text box with its RunningSum property set to
Over All or Over Group depending on what else your report is
doing.

If that doesn't doo what you want, then post back with more
details about your report and how you want this running
total calculated.

 

[Marshall Barton]

I have a report for a Doctors office, on this report is (for example) 25
head, 25 neck, 25 throat. will increase as time goes on. I would like to,
on my report have a running total of these.

I can get the report to total all of them. by using
= count ([Organ site]), in the report footer but cannot get them individually.

I am thinking I may have to go the way of a "make table query" and report
off of that.

I doubt there is any need for a temp table.

I can't see your tables so I can't tell if head, neck, etc.
are separate fields in the table or if they are values in a
single field (named ??). If you really want a normal
running total on each detail line, then please try using the
RunningSum text boxes I suggested before. If you need help
with that, explain what you tried, what happened and what
was wrong the results.

OTOH, if you only want a subtotal in a group footer or the
grand total in the report footer then, for separate fields,
use the Sum function. Or, for a single field, see Duane's
subreport idea.