Rename Column in Header

  • Thread starter Thread starter m stroup
  • Start date Start date
M

m stroup

I can't seem to force a name change to a field which is summed. It keeps
reverting back to "SumOfWhatever". Any suggestions. I am exporting my query
to a spreadsheet for charting and I don't want to have to change the column
headings there.
 
I can't seem to force a name change to a field which is summed. It keeps
reverting back to "SumOfWhatever". Any suggestions. I am exporting my query
to a spreadsheet for charting and I don't want to have to change the column
headings there.
Click to expand...

This is a GroupBy query?
You set the name of the column in the query by using:
MyColumnName:[FieldName] or whatever expression you wish to write

Whatever is before the colon becomes the name of the column.
 
Try to change it in the query by putting something in front of a colon (:)
like so:

The Sum of Whatever: [Whatever]

Or right click on the field; go to Properties; and change the Description
property.

I prefer the first option.
 
Back
Top