Rollup Sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that Access can calculate totals or averages in forms or reports (per
the Access Help topic "Calculate a Total or other Aggregate Values") but can
it also do rollup sums like MS Project does? For example, if I have a task
with three sub-steps (the WBS "indent" feature in Project), I can create a
column that automatically adds the hours required to perform the sub-steps to
show the total hours required to do the entire task. Can Access do something
similar? Currently, I have to take my Access data and manually put it into
Project, then allow Project to perform the calculations (because of the
sub-steps). Is there a way to keep everything in Access?
 
LotB said:
I know that Access can calculate totals or averages in forms or reports
(per
the Access Help topic "Calculate a Total or other Aggregate Values") but
can
it also do rollup sums like MS Project does? For example, if I have a
task
with three sub-steps (the WBS "indent" feature in Project), I can create a
column that automatically adds the hours required to perform the sub-steps
to
show the total hours required to do the entire task. Can Access do
something
similar? Currently, I have to take my Access data and manually put it
into
Project, then allow Project to perform the calculations (because of the
sub-steps). Is there a way to keep everything in Access?
Click to expand...
 
[Sorry for the first empty post]

Using the GROUP BY operator, you can "rollup" the data in a query. In a
report, you can use the 'Sorting and Grouping' dialog to define Groups to
allow for subtotals at many levels, as well.
 
Thanks. I'll give it a try.

LotB

[MVP] S.Clark said:
[Sorry for the first empty post]

Using the GROUP BY operator, you can "rollup" the data in a query. In a
report, you can use the 'Sorting and Grouping' dialog to define Groups to
allow for subtotals at many levels, as well.


--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

LotB said:
I know that Access can calculate totals or averages in forms or reports
(per
the Access Help topic "Calculate a Total or other Aggregate Values") but
can
it also do rollup sums like MS Project does? For example, if I have a
task
with three sub-steps (the WBS "indent" feature in Project), I can create a
column that automatically adds the hours required to perform the sub-steps
to
show the total hours required to do the entire task. Can Access do
something
similar? Currently, I have to take my Access data and manually put it
into
Project, then allow Project to perform the calculations (because of the
sub-steps). Is there a way to keep everything in Access?
Click to expand...
Click to expand...
 
Back
Top