Hi All
I have a table in my MS 2000 SQL Database server called employees. In this table I have 4 fields and data as follows..
Name Clock Hours Absent
D Jones 001 10 14/08/2007,15/08/2007
D Smith 002 18 13/08/2007,14/08/2007,15/08/2007
What I would like is to create a query that creates a row dor each date so the query would look like the following..
Name Clock Hours Absent
D Jones 001 10 14/08/2007
D Jones 001 10 15/08/2007
D Smith 002 18 13/08/2007
D Smith 002 18 14/08/2007
D Smith 002 18 15/08/2007
Is this possible to do?
Regards
Djbell
I have a table in my MS 2000 SQL Database server called employees. In this table I have 4 fields and data as follows..
Name Clock Hours Absent
D Jones 001 10 14/08/2007,15/08/2007
D Smith 002 18 13/08/2007,14/08/2007,15/08/2007
What I would like is to create a query that creates a row dor each date so the query would look like the following..
Name Clock Hours Absent
D Jones 001 10 14/08/2007
D Jones 001 10 15/08/2007
D Smith 002 18 13/08/2007
D Smith 002 18 14/08/2007
D Smith 002 18 15/08/2007
Is this possible to do?
Regards
Djbell