Report Totals

[cwh2724 via AccessMonster.com]

In Access 97 I have created a report that is printing Employee Name,
Production Total for the employee, Training Total for the employee, an
Employee Total, and then the next employee, etc. At report footer time, I
want to print the Total Production for the report, Total Training for the
report and then a report Grand Total.

I have been accumulating the totals in the Production/Training group Format
time, but in some instances the report totals were incorrect. I found a post
where "Totals collected through the events of the report are not accurate if
the user previews or prints some of the later pages for the report". In the
same post, it suggests adding an extra text box in the detail section and set
it with Running Sum Over All. I can't grasp how I can write criteria for the
extra text box so that one box contains the running sum for Production and
one box contains the running sum for Training. Each record contains a field
indicating Production or Training and then there is one field for the total
for that record. Can someone give me some advice on how to do this?

Thank you in advance for any assistance that you can provide.

 

[Duane Hookom]

If I understand correctly, you want to sum a subset of the numbers in your
report. If this is correct, check the thread from earlier today "Sum records
if condition..."

 

[cwh2724 via AccessMonster.com]

Thank you so much. That was just what I needed.