Form/Chart: Can anyone get rid of this 'Sum Of'?

[dr_shiva29]

I am creating this database for my friend and am at dead ends due to this silly issue thats causing me lot of trouble. I have a query, which sums up data from a table and when I try to present this data from the query in a chart form, access adds this 'Sum of' in the category title. Have spent hours searching the internet but nothing which could help.

Anyone here knows a possible solution? I have attahed the sample database, query and the form.

 

[Galaxiom]

Alias the fieldname in the RecordSource query.

Use this style in the field cell of the query designer
NewName: Sum(somefield)

Or in SQL
SELECT Sum(somefield) AS NewName, etc

 

[Severin]

In your case you can doubleclick on the sumofincome box and the table appears. Then just change the columnheadings in the table!~)

 

[dr_shiva29]

Alias the fieldname in the RecordSource query.

Use this style in the field cell of the query designer
NewName: Sum(somefield)

Or in SQL
SELECT Sum(somefield) AS NewName, etc

Thanks Galaxiom. I played around with your suggestion, and it worked!!!