Convert date

[Finn K K]

Hi all !
I have a date from- start 26-11-2007 to end 30-11-2007, and now i want to
convert this to 26-11-2007 (1)
27-11-2007 (1)
28-11-2007 (1)
29-11-2007 (1)
30-11-2007 (1)

--
Best Regards / Venlig Hilsen



Finn Kjølby Kristiansen

 

[John W. Vinson]

Hi all !
I have a date from- start 26-11-2007 to end 30-11-2007, and now i want to
convert this to 26-11-2007 (1)
27-11-2007 (1)
28-11-2007 (1)
29-11-2007 (1)
30-11-2007 (1)

I'm sorry, I have NO idea what you're talking about here.

What's the (1)?
Where is this date? in an Access Table in a date/time field? in a Text field?
someplace else?
What is the "this" that you want to convert? a set of five dates into one
date? On what basis?

John W. Vinson [MVP]

 

[Finn K K]

Hi John W Vinson.

First I will thank you for your interesting of helping me .

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, fro a Employee
“Clock in / out systemâ€.
They are also using the “Clock in / out system†to planed free, in this
example
At first , they pun 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



"John W. Vinson" skrev: