| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
| Web Query Help... | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
