Renaming query fields

[AndySuk]

Folks

Is it possible to rename the fields on a query so that the names aren't the same as the table that they're based on?

My query is based on a number of linked tables via a read-only ODBC connection to an Oracle database. The fields, because they're very customisable in the original database, have fairly uninformative names for my purposes such as "Father Code" or "Description" or "Code24".

If possible I'd like to change the field names on the query to such things as "Sow_name", "Po_number", "Mon_Time" etc. Something that I can more easily recognise when I'm writing my reports.

Thanks for your help.

Andy

 

[Trevor G]

If you place in a name before the field name and add the colon symbol that should work. Like this:

Person_Nameerson (Person being the original field name from the table)

Trevor

 

[AndySuk]

Awesome! that works. Thank you very much Trevor.

 

[Galaxiom]

A word of advice. Drop the underscore from your field and table name system. They aren't needed any you will find them useful later in broader naming contexts. VBA uses them automatically in event procedures and they can be useful in subform structures. Don't waste them on a fieldname.

Use this system:
SowName, PoNumber, MonTime.

Never use anything other than alphanumeric characters in the names.