Problem changing field names

  • Thread starter Thread starter Duane
  • Start date Start date
D

Duane

I have a table that consists of 12 fields that are named
M1 through M12 respectively. I would like to run a query
or macro that changes the field names in the table to
January through December respectively. My other problem is
this: Each month, I receive new data and the data in the
M1 field is the current month. Simply, the data I receive
each month is a rolling 12 months, so the query or macro
needs to assign M1 to the current month and M2 through M12
the months that preceded the current month. Any thoughts?

Thanks in advance for your help.
 
It sounds like your design is based on "flat file" concepts (like Excel)
rather than Relational concepts. Access is a relational database, a very
powerful means of handling data. I suggest that all 12 of your month fields
should be a single field: Actual or Month or some such.

You haven't told us much of how your application is designed so I can't help
much beyond the above. There are quite a few Access newsgroups. If you are
new to Access you might find tablesdesign and gettingstarted useful.

HTH
 
Here is my current process. First, I receive the flat
file, then I import it into Access. The date fields are
named M1-M12.

Using a make-table query, or possibly a macro, I would
like to rename the fields to the current month for M12,
previous month for M11, and so on.

Is there any way I can change these field names without
having to do it manually?
 
Back
Top