Problem with StartDate and StopDate

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello, 
I have a very simple MS access database to store vacation information with few data like first name, last name, startdate, stopdate, and location. I am trying to creat an ASP report to list: 1) day (e.g. Mon, Tue, Wed...) and 2) the persons on leave for that day. 
This sounds simple enough, but I am having problem with the report as far as the startdate and stopdate. In this case, I can't just select a startdate or stopdate to list the persons, but I need to list the individual day(or date) for the week/month that shows the persons on vacation. 

The report would look something like this:
Tues,  July 13, 2005 
  Brad Pitt 
  Jennifer Aniston 
  Tom Cruise 
Wed, July 14, 2005 
  Jennifer Aniston 
  Steve Martins 
Thur, July 15, 2005 
  Jennifer Aniston 
  Steve Martins 

and so forth... (In this case, Jennifer is on leave from 13 July (Startdate) to 15 July (StopDate) and Steve Martins is on leave from July 14 - July 15). 
I wish to generate a list of dates to show all the persons on leave on a particular date. 
Could someone show me the simple code(method) on how to do this. Does this involve a For...Next loop to get the date in between the startdate and stopdate? I am not exactly sure where to begin... 

Your help is greatly appreciated! 

Thanks, 

Sara 