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

dr_shiva29

New member
Local time
Today, 12:26
Joined
Aug 29, 2010
Messages
7
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.
 

Attachments

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
 
In your case you can doubleclick on the sumofincome box and the table appears. Then just change the columnheadings in the table!~)
 
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!!! :)
 

Users who are viewing this thread

Back
Top Bottom