Output Design Column Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I found my answer already. It's as simple as clicking on properties for that
column and changing the Caption.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum error on select query 1
Excel Comparing two columns 1
Totals for month and year 4
Bug? Using full identity expression in any arbitrary column works 4
How to display multiple IIf results in one column 1
Query Column Reserved Word 4
Help with VBScript/Access database 0
Query to select individual records 4

Back
Top