change a date query fra a single to a several

[Finn K K]

I’m coming from Denmark, so excuse me for the bad English.

I’ve got a table in an Access , I Have made by a Query, from a Employee
“Clock in / out systemâ€.
They are also using the “Clock in / out system†to planed free (holliday),
in this
example
At first , they put in the Employee number , next the start date
( 26-11-2007 ) and next the end date
( 30-11-2007 ) and at last the letter for Holliday “ H “ . and now the
problems begin.
Because all these information’s is taken into one records ( line )
Employee id Start date End date Letter for free H, …….
1234 26-11-2007 30-11-2007 H

And I need to have one records for etch day.
1234 26-11-2007 H
1234 27-11-2007 H
1234 28-11-2007 H
1234 29-11-2007 H
1234 30-11-2007 H

Now I can made a query for the single day, example If I got a 100 different
employee ,with different
Planning, I can make a query for the single day how many employees who got
Holliday.
I will looking forward to her from you

--
Best Regards / Venlig Hilsen



Finn Kjølby Kristiansen

 

[KARL DEWEY]

Create a table named CountNumber with field named CountNUM containing numbers
from 0 (zero) through your maximum spread. Use the query below, editing the
table and field names to use yours and then make it an append query to create
all the records you need.
SELECT Qaspec.X, Qaspec.[Actual Start Date], Qaspec.[Actual End Date],
DateAdd("d",[CountNUM],[Actual Start Date]) AS [Hours of case]
FROM CountNumber, Qaspec
WHERE (((DateAdd("d",[CountNUM],[Actual Start Date])) Between [Actual Start
Date] And [Actual End Date]))
ORDER BY Qaspec.X, Qaspec.[Actual Start Date], Qaspec.[Actual End Date],
DateAdd("d",[CountNUM],[Actual Start Date]);