To show each week and then the rows for each week for that person then group
first on WeekStart and then on EmployeeID. Give the WeekStart group a group
header. Whether you also give the EmployeeID a group header depends on
whether you want the name as a heading for a group of detail rows for each
employee or not.

Grouping on a unique value like EmployeeID ensures that no two employees with
the same name are lumped together (I worked with two Maggie Taylors once),
but it sorts the rows by the ID number not alphabetically by name. To sort
by name first group the report by WeekStart, then by the name, and then by
the EmployeeID, but give the EmployeeID group a group header, not the name
group if you want a heading for each person's rows. The report will then be
ordered within each week by the name, but each employee will be reported
separately even if they have exactly the same name.

Ken Sheridan
Stafford, England

Alaska1 wrote:
Just one more question. I have to group the date by the week and by person.
What is the best way to do it?

4/19/2010
Tom Smith 15 returns

That's because your newsreader has split the line over two. It should all be
a single line. This is something you need to watch out form when code is
[quoted text clipped - 81 lines]
5/24/2010 - 5/28/2010 5 time sheets returned
.

--
Message posted via http://www.accessmonster.com