Sum up fields in different rows to a new field in a query

[Jan e Porsböll]

Hi

I'm pretty new working with access queries and wonder if there is a solution for adding up fields in different rows to a new field.


I'm not familiar with VBA so examples of function in query design is appreciated.
Thanks!
Pls see ex under:
Jan P

Item	Week	Sales	Sum sales
A	1	5	5	Sum of week one or first week
A	2	8	13	Sum of week 1 and 2
A	3	12	25	Sum of week 2 and 3

[orange]

The subject to google is Running Total in Query.

see http://support.microsoft.com/kb/290136