Excel2000: Calculated field name in ODBC Query

[Arvi Laanemets]

Hi

I have a workbook with several ODBC queries from another Excel workbook. The
queries differ by WHERE condition. In general, query syntaxes are like
SELECT a.field1, a.field2, SUM(a.field3) AS 'Field3'
FORM `Drive:\Path\SourceWorkbook`.SourceTable a
WHERE ....
GROUP BY a.field1, a.field2
ORDER BY a.field2, a.field1;

My problem is, that for some queries AS fieldname part is working, i.e. in
return table the header for 3rd column is 'Field3', and in query window I
can activate from menu Records>EditColumn, for some of then sometimes isn't.
When I close query window for such query, the query syntax changes to
SELECT a.field1, a.field2, SUM(a.field3)
FORM `Drive:\Path\SourceWorkbook`.SourceTable a
WHERE ....
GROUP BY a.field1, a.field2
ORDER BY a.field2, a.field1;

in return table the column header will be Expr####, and Records>EditColumn
in query wizard menu is disabled.

Has someone some plausable explanation for such behaviour. And how to mend
it?


Thanks in advance!
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )