MS Query
 

Hi,

Does anyone know how to reference tables in the SQLs for MS Query?

eg. SELECT timestamp AS TimeLogged
FROM ......
WHERE .....

Thus naming the field header as TimeLogged instead of the databases field of
timestamp.

Ta

Neil

MS Query
 

When in Query, double click on the field name and enter the name under
heading name, alternatively edit the sql and enter after the filed name
type AS new name


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=520983