Sum in make table query field name

[bruegel]

Access 365.



I have a make table query I've used for years and a field called "Income" I put sum in Total box and it creates "Sum of Income" All fine and dandy

I copied the query as I wish to apply to different data set. This time created field is just "Income" not "Sum of Income"

I can't see any difference between the two queries. I even copied the SQL in each and compared character count.

The reason I ask is that the table with "Sum of Income" is used is series of nested queries and that means a whole series of changes which I'd rather avoid

Any ideas on how to get the "Sum of.." element back please?

Thanks for help

Pieter

[isladogs]

Use an alias in your query field
Sum of income : Income

[bruegel]

I realise I can do that but I have any number of queries using calculated fields and wish to understand the issue otherwise some queries may create "Sum of Sum of Income" which creates the same non-recognition of field name problem in nested queries.

Peter

[bruegel]

Sorry - thanks for the suggestion though. I wasn't belittling the reply

[isladogs]

That's fine but it wasn't what you asked.
Unless you post your query SQL, it's impossible for anyone to explain why it happened.

[June7]

Questions I have:

Why a process that requires making table?

Why saving aggregate data to table?