Total of Totals

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I've created a report based on a query (from tblEmp and
tblDetails) that gives me the SumOfHrsWkd, SumOfVAC,
SumOfBonus, SumOfPaidHrs, etc. They are entered into a
form. The report shows the sum of each employee's hours
broken down in HrsWkd, etc. between Week Start and Week
End. How can I show the Total of SumOfHrsWkd, SumOfVAC,
etc. on the report for the specified time?
Empl01 Hrs Wkd, VAC etc,
Hrs Wkd, VAC etc.
Total emp 1 HrsWkd, Vac etc.
Empl02 same as above, etc.
I've read the articles and posts but can't seem to find
one that relates to the Grand Total of fields with Start
and End dates for each employee? Thanks, all help much
appreciated.
 
Kelly said:
I've created a report based on a query (from tblEmp and
tblDetails) that gives me the SumOfHrsWkd, SumOfVAC,
SumOfBonus, SumOfPaidHrs, etc. They are entered into a
form. The report shows the sum of each employee's hours
broken down in HrsWkd, etc. between Week Start and Week
End. How can I show the Total of SumOfHrsWkd, SumOfVAC,
etc. on the report for the specified time?
Empl01 Hrs Wkd, VAC etc,
Hrs Wkd, VAC etc.
Total emp 1 HrsWkd, Vac etc.
Empl02 same as above, etc.
I've read the articles and posts but can't seem to find
one that relates to the Grand Total of fields with Start
and End dates for each employee? Thanks, all help much
appreciated.
Click to expand...


If you want to calculate the total of the values in the
report, just use a text box in a group header/footer and/or
the report header/footer with an expression like:

=Sum(HrsWks)
 
-----Original Message-----
I've created a report based on a query (from tblEmp and
tblDetails) that gives me the SumOfHrsWkd, SumOfVAC,
SumOfBonus, SumOfPaidHrs, etc. They are entered into a
form. The report shows the sum of each employee's hours
broken down in HrsWkd, etc. between Week Start and Week
End. How can I show the Total of SumOfHrsWkd, SumOfVAC,
etc. on the report for the specified time?
Empl01 Hrs Wkd, VAC etc,
Hrs Wkd, VAC etc.
Total emp 1 HrsWkd, Vac etc.
Empl02 same as above, etc.
I've read the articles and posts but can't seem to find
one that relates to the Grand Total of fields with Start
and End dates for each employee? Thanks, all help much
appreciated.
Click to expand...

Hi Kelly,
Based on what you said, I think that you can create the
total of the Hrs Wkd in the employee's footer. This will
enable you to have the report of total of the values in
each employee inside the report.
First, go to a sorting and grouping icon that is located
in the toolbar, and select the employer's ID and put the
group header and group footer to YES.
After you created, you can locate the total of any
specific sums that you want in the employer's ID footer
by using textbox.
For instance, Total = Sum(QryHrsWkd) <-- depend on your
query name)
In case if you want to get the grand total of all
employees, you can put the total in the Report's footer.

I hope this helps.
Sylvia
 
Back
Top