At 04:38 PM 7/25/2002 -0300, Ageu Duarte Junior wrote:

>I have a table with three Columns: The name is EmployeeTimeWork, and the
>columns are:
>
>EmplyeeID Char(3)
>DateWorked Date
>HoursWorked Time
>
>I need a statement to sum the hours worked between dates, I tried it:
>But doesn't Work.

Right. The problem is that you're using the time data type incorrectly.
It's not a number of hours, but a point during a day. For example, 10:00
is ten in the morning. You want it to be the sum of 5 + 5. Use a numeric
type.


Regards,

Ann
www.ibphoenix.com
We have answers.