I am using access and i would like to create a sql query that would return all dates.

For example

Select AllDate From Dates Where Date Betwwen #7/01/05# And #7/5/05#

it should return

7/01/05
7/02/05
7/03/05
7/04/05
7/05/05


Without having to create a table Dates.

Thanks for any help.