Hello

How can I do to solution this problem:

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:


SELECT SUM(HourWorked) FROM EmployeeTimeWork
WHERE EmployeeID = :ID
AND DateWorked >= :DateFirst
AND DateWorked <= :DateLast

But doesn't Work.





[Non-text portions of this message have been removed]