grand totals in report footer

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!
 
M

Marshall Barton

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?


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.
 
G

Guest

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?

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.
 
M

Marshall Barton

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;


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top