automatic column creation

[Barrowclough]

I am making a schools database that will also be an electronic registration system. I was wondering if there is anyway I can specify a perid between two dates and then access automatically create the columns between those dates for me.

[KnooKie]

when you say create those columns do you mean in a report/table/query ?

do you have a single date (you can use BETWEEN method)

or a start and end date (WHERE clause in query)

it may be wise to expand on what you are trying to achieve a bit more.