View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DFoster DFoster is offline
external usenet poster
 
Posts: 4
Default How do you rename table headers in a query using Offic 07?

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.