Fill date.

[kashif.special2005]

Hi,

I have a date table and there is only one column called "Date"

I want to fill date between 01/01/2011 to 12/31/2011 in "Date" column through query.



Thanks & Regards,
Kashif.

[RuralGuy]

Date is a RESERVED word and should not be used by you as the name of an object. http://www.allenbrowne.com/AppIssueBadWord.html
Then I would question the value of a table with only one field. And lastly, I don't think you can do that with a query. It will probably take a Recordset and a loop in code. Care to share WHY you feel you need such a table? There may be a more efficient way to achieve what you want.

[weekend00]

I use such a table in a few occasion.

I just go to Excel and fill a series of dates from 1/1/2011 to 12/31/2011, then copy and paste to a table in Access.

I use such a table to get all dates in a year, use left join with other tables to fill some data. I need this table because other tables don't have every date in them but I need all dates in the result.