Sumof Maxof Countof

[Angie]

When building a query and using sum, first, max etc. I get annoyed by the
'relabeling' of the column names. Especially when I have many columns I am
running computations on. Is there a way to supress this renaming other than
manually going into each column and doing it myself?

Example, let's sum the column "Cost". It becomes "SumofCost". I am currently
going into the query and renaming like this: Cost: [Cost] to keep it from
adding the "Sumof"

 

[Klatuu]

That's how you do it.

 

[Douglas J. Steele]

AFAIK, there's no way to prevent Access from changing the name.