access97 sql help

[arage]

hi,
the following:

SELECT newQuery.tempMonth, Sum(newQuery.forecast)
FROM newQuery
GROUP BY newQuery.tempMonth;

Becomes…

SELECT newQuery.tempMonth, Sum(newQuery.forecast) AS Expr1
FROM newQuery
GROUP BY newQuery.tempMonth;

In access97, why?

[arage]

that's why:

SELECT newQuery.tempMonth, Sum(newQuery.ActivationForecast) AS SumOfActivationForecast
FROM newQuery
GROUP BY newQuery.tempMonth;

[marist89]

Yes, access doesn't know what Sum(newQuery.forecast) should be named, so it assigns a column name to it.