I have a table with a 'Week' column that stores the beginning day of 
the week. The table has other columns among them being 
the 'year', 'month' and so on. How do I modify the table so that it 
has all the days for the given week. Say if the 'week' column has 
01/05/01, I want to add all the days for that week. The 'day' column 
(if it is created) would than have 7 entries for that week i.e. 01/05 
thru 01/11, with all the other fields being the same. Its throwing the 
relational concept out of the window, but I have 
to run some reports on 'day' basis rather than a 'week' basis. 

I'd appreciate any help.