Adding a new field to a table in Access 2000

[Martina]

I want to add a new field to a table each month end. the name of this field should reflect the previous month. For example when running the update in August 2006 the name of the field should be for July 2006, the format of the field should be as follows: 2006 07. Is there any way to create a function in Access to do this, thanks

 

[RuralGuy]

Hi Martina,
You may want to review your design. The passage of time should add records and not fields in a properly normalized database.

 

[FoFa]

There is just so much wrong with that. You make it hard to use that data in a menaingful way.
Besides in years you will run out of columns.
Better to create a table, with a foreign key to point back to your main record. THen have a date (like JUNE 2006) and store any related data to JUNE 2006 in that table on that row.

 

[MStCyr]

As mentioned in the other posts, you should rethink your design