field names for tables

[Milan]

Hi People!

I have tables being imported into my database (all ok now!), but i need to transfer the information into a new working table. Is there anyway i can get access to give me the names of new fields in each of the imported tables. As each table has a different number of fields!.

Thanks

 

[IMO]

You can change field names in a query by typing it before the selected name

YourNewName:OriginalName

See screen shot

IMO

 

[Milan]

Thanks for the example!. That work fine!

 

[IMO]

Glad you got it sorted

IMO