Mr. Cetin,

Yes, i agreed with you that Job Nos. and times are changing,
But if i make query based on Date, Or (Date and Job No.) Or (Date And Employee And Job)

(ie, the Table structure and data like as follows)

Date EmpCode JobNo. Time
01/04/2005 A Job1 3
01/04/2005 A Job2 3
01/04/2005 A Job3 2
01/04/2005 B Job1 8

How will be the Sql Satemant.

Rgards