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
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