Sum total hours worked

[Stacey]

I need to sum total hours worked by a specific employee
for a specific project for an entered time frame --
The information currently looks like this:

EmployeeLastName ProjectID SumofBillableHours DateWorked
smith red 2
6/11/2003
smith red 4
6/30/2003

The problem is that the hours are not actually a sum --
how can this be done.
Thanks.

 

[Michel Walsh]

Hi,


I would have said:


SELECT EmployeeLastName, SUM(SumOfBillableHours)
FROM myTable
WHERE DateWorked BETWEEN this AND that
GROUP BY EmployeeLastName


where this and that are the date limit for the time frame you want to
consider.


Hoping it may help,
Vanderghast, Access MVP