How do you rename table headers in a query using Offic 07?

  • Thread starter Thread starter DFoster
  • Start date Start date
D

DFoster

In older versions you could use AS after the field name and replace the name,
now that doesn't work. Example would be select dwdata.lstnme AS "Last".
With this in the query it would bring back a column heading of Last instead
of lstnme.
 
Are you using MS Query?


I just did this in MS Query with Excel 2007, using this SQL

SELECT Activity.LocationSize, Activity.Function AS 'Fnctn',
Activity.ActivityCount
FROM Activity Activity, location location
WHERE Activity.LocationSize >= location.Lbound AND Activity.LocationSize <=
location.Ubound

It returns the data to Excel with the 2d column's heading being 'Fnctn' -
it unfortunately includes the single quotes in Excel
 
Back
Top