SQL for date range in ACCESS

[geek491]

I want an SQL that displays all the days within the range given.


SELECT <days> from <dual> where days between '01/01/2006' and '12/12/2006'

Dual table is precent in Oracle but what is its equivalent in ACCESS?


If i run the above query with a different date range i should get all the days between those two date ranges.

[Tanis]

Try this. Change your table and field name.

SELECT YourTable.DateField
FROM YourTable
WHERE (((YourTable.DateField) Between #1/1/2006# And #12/12/2006#));

[NeoPa]

I believe there is no built-in facility to do this (would that there were).
You can create the data using a For loop in code, but it's messy and you'd have to have somewhere to store it, even if only temporarily.