Grouping

[Guest]

Hello
I have a report that I need to be sorted by Last Name with a group footer showing the number of hours for each employee. My problem is that the report combines people with the same last name. Below is the record source structure

Employee Number Reg Hours Ot Hours DT Hours Last Name First Name Mid Init Dat
123456789 8 2 0 Murphy Tom N 06/01/0
125489874 8 0 0 Murphy Matt L 06/01/0

I need the report to total the hour columns for each employee and be sorted by last name. I would appreciate any pointers anyone has
Thank
Bob

 

[Duane Hookom]

You could just sort first by LastName and then only group by EmployeeNumber.

--
Duane Hookom
MS Access MVP
--

OK All,
I believe I got it. I created a Last Name Header/Footer and an Employee

Number Header/Footer. I put the Last Name field in the Last Name Header and
made it invisible. I put the display for the employees number and name in
the Employee Number Header and the totals in the Employee Number Footer.
This way it sorts/groups by last name and totals by the employees number.

Bob

----- Bob R wrote: -----

Hello,
I have a report that I need to be sorted by Last Name with a group

footer showing the number of hours for each employee. My problem is that the
report combines people with the same last name. Below is the record source
structure:

Employee Number Reg Hours Ot Hours DT Hours Last Name First Name Mid Init Date
123456789 8 2 0

Murphy Tom N 06/01/04

125489874 8 0 0

Murphy Matt L 06/01/04

I need the report to total the hour columns for each employee and be

sorted by last name. I would appreciate any pointers anyone has.