Automatic week ending date for year in form columns

[kvar]

I have a datasheet form I'm trying to create, the columns are things like Department, Division, PayRate, CName, etc. That information is all based off of a table. Now what I need are columns off to the right representing the weeks in the fiscal year. So the header would be, for example, Week Ending 10-25-15. But I need one for every week of the fiscal year, ours is April through March. So from April of this year through March of next year I need a column with every Sundays date in it.

There is no way I'm going to create a table and sit here with a calendar to type them all in! There must be some way to automate this right? I know how to use dateparts, but is there some way to put that in the form itself so that it creates a column with each date? Or maybe I would have to switch to a continuous form?

Any help is greatly appreciated!

 

[spikepl]

No you don't need to create columns containing data in their names - that's Excel. This is Access. Here you write records. In this way your data grows vertically and does not require any changes in forms or reports.

You can display it like you want using crosstab queries or excel.

 

[kvar]

That's exactly why I don't want to write it into a table, that seems unnecessary. But I need the dates to display on the header of the form then underneath that the managers need to put in the number of hours they want to budget for that person to work for each week.
I need them to fill it out for each week, then I can update the tables and run queries at the end of each quarter to show the variance on what they spent.
So regardless, I need some way for it to display horizontally with all their employees names showing vertically so that they can fill in the corresponding hours.