List Dates between Start and Finish Dates

[Buddus]

I have a simple table [Class List] with headings: Class Number Class Start Class Finish








I need a query that lists every date between Class Start and Class Finish for all classes. I don’t want to have to do a yearly table if possible.
I have Access2010. The table has about 25 entries and i know the query will be huge but thats what I need.

Appreciate any help!!

Danny

[JoeM]

If you want it in a query, I think you will need to create a yearly calendar table to compare to. Select queries can only return or summarize records that are already there, they really can't create new records that don't exist (a Make Table or Append Query can, but then you are creating records which may not be too efficient).
The only other way to get a listing of dates that I can think off would be to use VBA, but I think that would have to write the results to a file or a new table.

Creating a table of dates is pretty easy. I would just create it in Excel and import it into an Access table. You could do multiple years at a time (i.e. create 10 years of dates at once).