Clocking Report

Hi,

I have to report the clocking for our company employees. The main clocking table is just employee number & Date/Time clocked. An employee can have any number of clockings per day.

Would it be possible to create a select statement so that there is just 1 row per day for each employee?

[Table Rows]

piet, 2007-02-23 07:59

piet, 2007-02-23 13:01

piet, 2007-02-23 13:55

piet, 2007-02-23 16:35

[Result for SQL statment]

Piet, 2007-02-23, 07:59, 13:01, 13:55, 16:35

Any help will appreciated.

Thanks

Search for Dynamic Pivot and you will find solutions for problems similiar to your post.