sum a field in a Query

[mattgsh]

I want to sum a particular field in access 2003. But I need to sum the value in 12 month blocks and display the results in another Query, so i can have the total value for 2008, 2009 etc. I'm unsure how to do this. Anyone can help me?

 

[pr2-eugin]

Could you give an example of what you need to do? How your data is in the table?

 

[mattgsh]

I have monthly Electircal use for different buildings in a field in a query. They are arranged monthly. I want to create a Query that shows the annual electrical use for the building. Therefore i need to calculate the sum of the 12 months for the given year in another query. But this is a rolling 12 month so every year the total will change.

 

[vbaInet]

See the following link on how to sum data by using a query and GROUP BY Year([YourDateField])

http://office.microsoft.com/en-us/access-help/sum-data-by-using-a-query-HA010096310.aspx

 

[mattgsh]

I'm using Access 2003. Therefore the total row isn't a feature

 

[vbaInet]

I won't have asked you to try something if I thought it never existed. That even existed in Access 1997. Follow the link through, right-click somewhere in your criteria and you should find the 'Total' menu item within the pop-up.