Sumof Maxof Countof

  • Thread starter Thread starter Angie
  • Start date Start date
A

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"
 
Thanks guys, that is what I thought...but was hopeful that there was
something I was missing.

Douglas J. Steele said:
AFAIK, there's no way to prevent Access from changing the name.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Angie said:
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"
Click to expand...
Click to expand...
 
Back
Top