Access Query Fill Down

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to create a query like fill down in excel, suppose I enter a date in text0=07/01/2011 and in text2=08/15/2011, now I want to create make-table query that will show date fill down by 1 day increase from 07/01/2011 to 08/15/2011, like below.
<o> </o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:date Month="7" Day="1" Year="2011">07/01/2011</st1:date>
<st1:date Month="7" Day="2" Year="2011">07/02/2011</st1:date>
<st1:date Month="7" Day="3" Year="2011">07/03/2011</st1:date>
<st1:date Month="7" Day="4" Year="2011">07/04/2011</st1:date>
.
.
.
.
till <st1:date Month="8" Day="15" Year="2011">08/15/2011</st1:date>
<o> </o>
Thanks,
Kashif. <o></o>

 

[boblarson]

1. Why a make table? Why not create a table and then delete the data and refill? Make tables bloat the database file worse than refilling the data.

2. There really isn't a way to get that using just a query (at least that I know about). You would need to do it in conjunction with a function. And you could just use a recordset to iterate through and do it. So the big question is what other fields are going to be in this table?