Query showing all the dates within a range

[bugsy]

Is it possib;e to create a query that would all the dates withn a range of Date1 and Date ?
Ex if I have

Filed Date1 Date2
x 1/1/07 1/3/07
c 1/6/7 1/8/7

for query to show

Field Date
x 1/1/7
x 1/2/7
x 1/3/7
c 1/6/7
c 1/7/7
c 1/8/7

 

[Luka]

Hi,

Create query:

Put desired date into field and set WHERE condition: between Date1 and Date2.

Hope it helpes.