Output Design Column Names

G

Geoff

I am creating a simple query from several database tables. The problem is the
column names are very criptic. I want the results of the query to display a
readable name. Ex. AcctNbr and RelPrntNbr should display as AccountNumber and
RelationParentNumber.

What is the Expression to convert these column names?

Thanks
Geoff
 
G

Geoff

I found my answer already. It's as simple as clicking on properties for that
column and changing the Caption.
 
B

Brendan Reynolds

SELECT FieldName AS Alias

.... were "FieldName" is the actual name of the field, and "Alias" is the
name you want to use for it in the query.
 
Top