S
Steve Steinpreis
Guest
re: Post Totals by?
I am generating a report that shows production from various lines. Each Line has 14 presses and can have various models in each press. Below is a view of the report. I need totals by models, remember, the models can vary as dies are changed.
We also count anytime a press is down and I need these counts total by various model.
Press Model Rounds
1 5FVG400 23
1 DOWN 1
2 5FVG400 22
2 DOWN 2
3 5FHH500 23
3 DOWN 1
4 5FHH500 24
5 5FTT340 23
5 DOWN 1
6 5FTT340 22
6 DOWN 2
Would like report to Total like this
Totals
5FVG400 45
DOWN 3
5FHH500 47
DOWN 1
5FTT340 45
DOWN 3
When I use =sum([RoundsCount]), it puts another line under each ModelNo row on report. Cannot create Totals area!
Thanks for any help.
Steve
I am generating a report that shows production from various lines. Each Line has 14 presses and can have various models in each press. Below is a view of the report. I need totals by models, remember, the models can vary as dies are changed.
We also count anytime a press is down and I need these counts total by various model.
Press Model Rounds
1 5FVG400 23
1 DOWN 1
2 5FVG400 22
2 DOWN 2
3 5FHH500 23
3 DOWN 1
4 5FHH500 24
5 5FTT340 23
5 DOWN 1
6 5FTT340 22
6 DOWN 2
Would like report to Total like this
Totals
5FVG400 45
DOWN 3
5FHH500 47
DOWN 1
5FTT340 45
DOWN 3
When I use =sum([RoundsCount]), it puts another line under each ModelNo row on report. Cannot create Totals area!
Thanks for any help.
Steve
