grand totals in report footer

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

Guest

I'm trying to create grand totals in a footer. The tables/reports of data are:

Projects
ProjectsTasks
ProjectsTasksScientists
ProjectsTasksScientistsUpdates

I have a running total for the updates in the footer for
ProjectsTasksScientistsUpdates. What I'd like to do is make a grand total for
updates in the ProjectsTasks footer so that I know how much total is spent
per task.

I've added the ProjectsTasksScientistsUpdates table to the record source for
the ProjectsTasks reports but this of course, returns some crazy stuff.

Considering this design how can I create the grand totals?

Thanks!
 
JohnLute said:
I'm trying to create grand totals in a footer. The tables/reports of data are:

Projects
ProjectsTasks
ProjectsTasksScientists
ProjectsTasksScientistsUpdates

I have a running total for the updates in the footer for
ProjectsTasksScientistsUpdates. What I'd like to do is make a grand total for
updates in the ProjectsTasks footer so that I know how much total is spent
per task.

I've added the ProjectsTasksScientistsUpdates table to the record source for
the ProjectsTasks reports but this of course, returns some crazy stuff.

Considering this design how can I create the grand totals?
Click to expand...


It's not at all clear that you need to use a RunningSum text
box for any total. Why won't a text box (in *any* group
and/or report header/footer) with an expression like
=Sum(somefield) do what you need?

If the value to be totaled is a very complex calculation,
then a RunningSum text box may be required. In this case
the next higher group total or report total can be
calculated using a second RunningSum text box.
 
Hi, Marshall.
It's not at all clear that you need to use a RunningSum text
box for any total. Why won't a text box (in *any* group
and/or report header/footer) with an expression like
=Sum(somefield) do what you need?
Click to expand...

I need a RunningSum for each Scientist per Task. That was easy to do in the
ProjectsTasksScientistsUpdates report.

I tinkered around some more and also referred to something Duane posted in
another thread regarding something similar and came up with this for the
ProjectsTasks report:

SELECT tblProjectsTasks.*, qryProjectsTasksUpdatesTime.SumOfProjectHours,
qryProjectsTasksUpdatesTime.SumOfProjectMinutes,
qryProjectsTasksUpdatesTime.SumOfPlantHours,
qryProjectsTasksUpdatesTime.SumOfPlantMinutes,
qryProjectsTasksUpdatesTime.SumOfMaterialCost
FROM tblProjectsTasks INNER JOIN qryProjectsTasksUpdatesTime ON
tblProjectsTasks.TaskID = qryProjectsTasksUpdatesTime.TaskID;

So far this is working.
 
JohnLute said:
I need a RunningSum for each Scientist per Task. That was easy to do in the
ProjectsTasksScientistsUpdates report.

I tinkered around some more and also referred to something Duane posted in
another thread regarding something similar and came up with this for the
ProjectsTasks report:

SELECT tblProjectsTasks.*, qryProjectsTasksUpdatesTime.SumOfProjectHours,
qryProjectsTasksUpdatesTime.SumOfProjectMinutes,
qryProjectsTasksUpdatesTime.SumOfPlantHours,
qryProjectsTasksUpdatesTime.SumOfPlantMinutes,
qryProjectsTasksUpdatesTime.SumOfMaterialCost
FROM tblProjectsTasks INNER JOIN qryProjectsTasksUpdatesTime ON
tblProjectsTasks.TaskID = qryProjectsTasksUpdatesTime.TaskID;
Click to expand...


Not what I was thinking, but if that's the record source for
a subreport, it should also fo the job.

I still don't understand why =Sum(ProjectHours) in the Tasks
group footer won't work.
 
Back
Top