I know this type of uestion has been asked many times over, but I've yet to find a answer that I've been able to make work.

I have One table that I'm working with. The Fields related to this problem are EMP_NO (employee Number), START_DATE, END_DATE.

Example Data:
EMP_NO - - - START_DATE - - - END DATE
-----------------------------------------
313505 12/12/04 12/15/04
234978 07/16/04 08/05/04
------------------------------------------

The Output of the query I would like would be based upon the EMP_NO:
EMP_NO - - - DATES WORKING
------------------------------
313505 12/12/04
313505 12/13/04
313505 12/14/04
313505 12/15/04
234978 07/16/04
234978 07/17/04
and so on....
------------------------------

Any help appreiciated.Thanks

You need to write code to create these records for you but I don't see why you would need this if you have the Start and End Date already.

Well, honestly you caught me. I've been more that able to work with the satr/end date situation within my web app. And I'm almost complete, but a co-working who is designing reports off of my Datebase/web app, is having trouble with the start/end format. I figured that if I'm able to provide those specific dates for him he would be able to complete his end fo the job...quicker.

And I'm almost complete, but a co-working who is designing reports off of my Datebase/web app, is having trouble with the start/end format.

What sort of trouble is he having?

He is trying to show in a crystal report a list of personel per date that are scheduled to work. Example:


12/04/78
Person#1
Person#2
Person#3
Person#4

12/05/78
Person#2
Person#4
Person#5
Person#6


And without specific dates he can't figure out how to grab each date(within the START_DATE and END_DATE fields) and generate a list of personnel.