Transform a field name in date and add a new field in table

[nilses]

Hello,

I have a problem with my access base and i would like your advice. I have two tables in my base, in the first “Data” I have a field which name “Mtt”. I would like to transform the field name “Mtt” by the name of month preceding (if i‘am in August, I would like July like in the base DataAfter) but I would like make it by the code but i don’t know how can i do this ?. Is it possible to use the function Now().

In the second Table “Database” I have a lot of field and I would like insert a new field each month. I would like take the data “July” in the base “DataAfter” and insert this new field in the table DataBase. I would to do this operation each month. How can I do this?.

Thanks for your help,

Nilses

 

[ColinEssex]

It sounds suspiciously like you are trying to recreate a spreadsheet in Access by having the field names across the top.

In Access you go down the table and each line is a record. So as an example in an orders table it may look like this

IDNo. . . . . . . . CompanyID. . . . . . . .OrderDate

2354. . . . . . . . .23. . . . . . . . . . . . . 01/07/05
954. . . . . . . . . .12. . . . . . . . . . . . . 26/06/05
etc

Col