display dates between 2 dates

[kirkland via AccessMonster.com]

Hi

I have a table with FromDate and ToDate that displays the period in which a
product is available. Is there anyway i can display the actual dates between
this period so i can use the dates to make a booking. Eg.

FromDate ToDate
12/02/2006 15/02/2006

what i want the query to display is:
12/02/2006
13/02/2006
14/02/2006
15/02/2006

This is possible?

 

[Przemys³aw Rachwa³]

Hi

I have a table with FromDate and ToDate that displays the period in
which a product is available. Is there anyway i can display the
actual dates between this period so i can use the dates to make a
booking. Eg.

FromDate ToDate
12/02/2006 15/02/2006

what i want the query to display is:
12/02/2006
13/02/2006
14/02/2006
15/02/2006

This is possible?

You need a table with number or date, there no diffrent way

if You Have a that table you can create a query with BETWEEN

for excample:

TAB_TMP (date from 2000-01-01 to 2010-12-31)

SELECT
TAB_TMP.DATA
FROM
TAB_BETWEEN AS [DATE], TAB_TMP
WHERE
(((TAB_TMP.DATA) Between [TAB_BETWEEN]![FromDate] And
[TAB_BETWEEN]![ToDate]) AND
((DATE.id)=1));


((DATE.id)=1)); - this is a very important!! in this place you szhow
what range wont show