MS Query

N

Neily

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
 
G

Gary Brown

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
 
Top