Rename Column in Header

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.
 
F

fredg

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.
 
J

Jerry Whittle

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.
 
Top