In the Query Grid of your Totals Query, precede the field name of the summed
field by itself and a colon. For a totals query on the Order Details in
Northwind.MDB, that gave me the SQL:
SELECT [Order Details].OrderID, Sum([Order Details].Quantity) AS Quantity
FROM [Order Details]
GROUP BY [Order Details].OrderID;
And running the query showed "Quantity" as the column header, where the
normal totals query gave the following SQL:
SELECT [Order Details].OrderID, Sum([Order Details].Quantity) AS
SumOfQuantity
FROM [Order Details]
GROUP BY [Order Details].OrderID;
and showed "SumOfQuantity" as the column header.
Larry Linson
Microsoft Access MVP
"Louis" <lo*******@lycos.com> wrote in message
news:13************************@posting.google.com ...
Is there a switch or a setting in Access so that a group by query
doesn't return a field name SumOf(original field name)? Especially
when you chain multiple queries together you'd get SumOfSumOfSumOf....
Anyone know? TIA.