Don't need a heading telling me it's a sum

[JordanR]

This may be a silly question, but when I do a query that sums Access of course renames the heading "Sum of Blah." Is there any way to stop it from doing that?
I know I can name it back by putting an expression in the query, but I have two HUGE queries that would make this extremely cumbersome. Any way to just make it not do that?

 

[Dogbert]

You could run a second query ontop of the first. Something like:

Select A, B, [Sum of Blah] as Blah, C, D
From [Sum of Blah query]

I haven't found a way around listing all the field names out. A pain I know!

 

[Banana]

No need for second query.

In the first query and I'm assuming you're using "Totals" row to select Sum, select the fieldname and do this:

NameToShow: FieldName

Alternatively, on View -> SQL View, and add this:

SELECT Sum(FieldName) AS NameToShow FROM....[/code]