Month Change problem

[dwight1]

I have a database that defines the month field as
EMC1
EMC2
EMC3
EMC4
EMC5
EMC6
EMC12

I gave aliases to them as below

Emc1 -- Jan
Emc2 -- Feb
Emc3 -- Mar
Emc12 -- Dec

The problem is, i have various instances of the adp. Most of the reports require current month and last month activity. Example,

Name Oct Sep

xxx 123 425

Now at the flip of the month, i have to change the field names from Oct to Nov and Sept to Oct to reflecet the current data. With many instances of adp it is hard to keep track by going to each desktop and changing the field name.

My question is, i want to define the field names in the query itself for exampl

Name Currentmonth lastmonth

xxx 234 123

can i schedule/work a way where i can say at the change of each month, change the name to reflect current month, last month so that i do not have to change them on the form.

Hope i make sense.

Thanks for your help.

Dwight