Create a new column in a table using a form

[WineSnob]

Each month I have to add a new column in a table for the current month. (jan11, feb11, etc...) Is there a way to do this using a form where I can type in the monthyear in a textbox and then click a button to create the new column in the table tblMasterData?

 

[John Big Booty]

That would seem to be in breach of the rules of Data Normalisation.

Now why do you think you need to add a new field for each month

 

[WineSnob]

I will read up on normalisation. To answer your question....I really don't know what I am doing but I keep trying. I am sure I will learn a lot. Thanks for the link....

 

[Khalid_Afridi]

Now why do you think you need to add a new field for each month

Because I want my table with as many as good fields in it

 

[gemma-the-husky]

the point is - rather than add a new column for the date - just add a date field to each record

then you just use a query to pick (ieffectively filter) the records relating to the month (range of months) you want to see.

no redesign needed ever.


generally a "good" structure is achieved (other things being equal) with tables that have many rows and few(er) columns.

 

[vbaInet]

... and after you've got a solid structure you can look into using a Crosstab Query because I suspect you may want the month fields for some sort of analysis.

 

[WineSnob]

That all makes sense........I'll do that.